NTSB investigations, 2006
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE year(c.\"eventDate\") = 2006 ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2006 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA07CA015Accident · Minor injuriesData collectionFinal reportBellanca BL-17-30 · Lantana, FLThe pilot's improper preflight planning/decision which resulted in total loss of engine power due to fuel exhaustion.NTSB LAX07LA032Accident · 2 fatalLimited investigationFinal reportKolb MK III · Paulden, AZfailure of the pilot to maintain an adequate airspeed that led to a stall/spin.NTSB DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.NTSB DEN07CA023Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Fe, NMthe pilot's failure to maintain directional control during the landing roll, and his failure to maintain airspeed which resulted in a stall and hard landing.NTSB NYC07LA027Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Williamsburg, VAThe pilot's improper decision to depart into adverse weather conditions. Contributing was the gusty wind conditions.NTSB LAX07LA031Accident · No injuriesLimited investigationFinal reportRyan Navion B · Riverside, CAA leak in the fuel selector valve and gascolator that resulted in fuel starvation on takeoff due to air leakage into the fuel system. A contributing factor in the accident was the inadequate annual inspection performed by other maintenance personnel.NTSB DFW07LA024Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pocasset, OKThe "abnormally high" oil temperature indication and smoke in the cabin for undetermined reasons. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB NYC07LA026Accident · 1 fatalLimited investigationFinal reportVogel Glastar 41 · Snow Shoe, PAThe builder's improper installation of an additional alternator. Contributing to the accident were the night lighting conditions.NTSB NYC07FA025Accident · 1 fatalField investigationFinal reportCzech Aircraft Works CH 601 XL RTF · Basye, VAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.NTSB MIA07LA014Accident · No injuriesLimited investigationFinal reportCessna 150J · DeFuniak Springs, FLThe loss of engine power for undetermined reasons.NTSB MIA07LA013Accident · Minor injuriesLimited investigationFinal reportWinter J.T/Johnson Kitfox III · Southwest Ranch, FLThe owner/builder's improper maintenance/installation of the propeller which resulted in a propeller blade coming loose and separating from the hub.NTSB LAX07CA034Accident · No injuriesData collectionFinal reportBell 206B · Boulder City, NVthe pilot's inadequate planning and decision in his failure to reduce the engine throttle to ground idle prior to exiting the helicopter.NTSB DFW07FA023Accident · 2 fatalField investigationFinal reportMcCutchan Glasair · Mineral Wells, TXThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. A factor was the loss of engine power due to fuel exhaustion.NTSB DFW07CA025Accident · No injuriesData collectionFinal reportEiben Theodore Quickie Q-200 · Denton, TXThe loss of control during takeoff as result of the failure of the right wing for undetermined reasons.NTSB ATL07LA016Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Memphis, TNThe captain's inadequate visual look out during taxi.NTSB ATL07CA017Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-C1 · Raleigh, NCThe pilot's failure to maintain airspeed during a go-around, which resulted in a inadvertent stall.NTSB SEA07FA016Accident · 1 fatalField investigationFinal reportBeech D35 · Shelton, WAThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion, and his failure to maintain sufficient airspeed to avoid a stall during the subsequent forced landing. A factor associated with the accident is the inadvertent stall.NTSB ATL07CA018Accident · No injuriesData collectionFinal reportGrumman G-164B · Pine Hill, ALThe pilot's improper fuel management resulting in a total loss of engine power in cruise flight due to fuel exhaustion, subsequent forced landing to non suitable terrain, and an on-ground collision with tree stumps on the landing roll out.NTSB NYC07CA024Accident · No injuriesData collectionFinal reportUtva 66 V-51 · Hilton, NYThe pilot's inadequate visual lookout, which resulted in a collision with a dock during takeoff.NTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.NTSB DCA07WA016Incident · No injuriesForeign investigationBoeing 767-2QS · Bristol, United KingdomNTSB CHI07LA021Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Milwaukee, WIThe failure of ground personnel to verify the clearance between the airplanes prior to signaling the crew tha the crew of the other airplane that they were cleared to taxi.NTSB NYC07IA023Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland EC135T1 · Harrisburg, PAThe pilot's inadequate preflight preparation, which resulted in the cyclic stick lock not being disengaged prior to lift-off, and his subsequent inability to control the helicopter. Contributing to the accident was the operator's inadequate procedures, the…NTSB LAX07CA030Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Glendale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.NTSB DCA07WA009Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Paris, FranceNTSB CHI07FA020Accident · No injuriesField investigationFinal reportAirbus A-320-200 · Chicago, ILThe pilot-in-command of the other airplane failed to maintain clearance with the parked airplane during taxi for takeoff.NTSB DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.NTSB DEN07IA021Incident · No injuriesIncident investigationFinal reportBeech P35 · Los Alamos, NMthe failure of both pilots to maintain adequate visual lookout during the visual approach. A contributing factor was the failure of N5368E's pilot to communicate his intentions on the Common Traffic Advisory Frequency.NTSB ATL07LA014Accident · 1 fatalLimited investigationFinal reportCarlson Lancair Propjet · Dalton, GAThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. Contributing to the accident was the pilot's mismanagement of the fuel supply, which resulted in loss of engine due to fuel starvation.NTSB NYC07LA022Accident · 1 fatalLimited investigationFinal reportMonard RAF 2000 GTX · Ridgely, MDThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.NTSB LAX07TA029Accident · No injuriesFinal reportEurocopter France AS350B3 · Apple Valley, CAthe pilot's improper use of the collective control during a practice hover autorotation, which resulted in a hard landing. A factor in the accident was the certificated flight instructor's inadequate supervision of the maneuver.NTSB LAX07CA028Accident · Minor injuriesData collectionFinal reportStrategie Ballloon Amazon · Page, AZThe pilot's failure to identify grass clippings in the balloon envelope during a preflight inspection, which resulted in the balloon catching fire in flight.NTSB DFW07FA020Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Danville, ARFailure of the number 5 cylinder which resulted in oil starvation and the subsequent loss of engine power, and the pilot's inability to see the transmission line during the forced landing. Factors Contributing to the accident were the dark night and the…NTSB DFW07FA019Accident · 2 fatalField investigationFinal reportCessna 172S · Hominy, OKThe pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.NTSB DEN07CA019Accident · No injuriesData collectionFinal reportLuscombe 8F · Wellsville, KSA loss of engine power due to the ingestion of the number 2 intake valve into its cylinder. Contributing factors included the pilot allowing the airspeed and altitude to drop, making a safe landing not possible.NTSB ANC07FA006Accident · 1 fatalField investigationFinal reportCessna 180E · Cordova, AKA loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and collision with an embankment.NTSB LAX07FA026Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dev. CH601XL Slsa · Yuba City, CAIn-flight structural failure of the horizontal stabilizer and wings for undetermined reasons.NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.NTSB SEA07FA014Accident · No injuriesField investigationFinal reportBell 407 · Kalispell, MTOn-speed failure of the second stage turbine wheel as the result of engine oil starvation. The lack of maintenance oversight was a contributing factor.NTSB MIA07WA023Accident · 1 fatalForeign investigationBell 206L · Antioquia, ColombiaNTSB CHI07LA018Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Chester, ILThe fatigue failure of the turbocharger shroud which resulted in oil starvation to the engine. A factor was the muddy field.NTSB NYC07LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · McHenry, MDThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a loss of engine power during takeoff-initial climb.NTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.NTSB CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.NTSB MIA07FA011Accident · 2 fatalField investigationFinal reportBeech BE-76 · Port Orange, FLThe flight instructor's inadequate preflight planning which resulted in fuel exhaustion.NTSB MIA07FA005Accident · No injuriesField investigationFinal reportBritish Aerospace HS 125-700A · Fort Lauderdale, FLThe failure of the flight crew to extend the landing gear. Contributing to the accident was the inoperative audible landing gear warning system.NTSB LAX07WA033Accident · Serious injuriesForeign investigationCessna 207 · Townsville, Australia