NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 MIA96LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAthe pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.NTSB LAX96LA126Accident · Serious injuriesLimited investigationFinal reportWorthington BD-5B · San Martin, CAthe pilot/builder's improper installation (overtorque) of the ignition switch on the instrument panel, which caused an internal switch failure and subsequent malfunction of the ignition system.NTSB LAX96LA125Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Auburn, CAfailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve.NTSB FTW96LA142Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Jasper, TXFailure of the pilot to ensure that the other person (outside the airplane) remained clear of the operating propeller, and failure of the other person to maintain awareness of the hazardous condition. A factor relating to the accident was: the other person…NTSB FTW96LA138Accident · No injuriesLimited investigationFinal reportCessna 182A · Walsenburg, COFailure of the pilot to maintain directional control of the airplane after the left main tire went flat during the landing roll. The flat tire was a related factor.NTSB FTW96LA137Accident · Minor injuriesLimited investigationFinal reportBell B206-BIII · Chandler, OKthe reported loss of engine power during a go-around for undetermined reason(s).NTSB CHI96LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pittsburg, KSan inadequate annual inspection by maintenance personnel, a deteriorated muffler, and pilot incapacitation due to carbon monoxide.NTSB CHI96LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Ankeny, IAthe pilot's poor judgment in attempting flight operations in the existing wind condition, and the high gusting wind.NTSB ANC96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cooper Landing, AKthe pilot's selection of unsuitable terrain for landing. Soft snow conditions were a factor in the accident.NTSB ANC96LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Nome, AKthe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain adequate altitude/clearance from terrain. Low ceilings and snow covered terrain were factors in the accident.NTSB NYC96LA069Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · South Wales, NYthe pilot's improper flare and failure to maintain directional control during landing.NTSB MIA96LA088Accident · No injuriesLimited investigationFinal reportBell 206L4 · Chiefland, FLImproper cyclic and collective input by the pilot-in-command resulting in the hard landing during the autorotative landing. Contributing to the accident was the total loss of engine power due to undetermined reasons.NTSB DCA96RA034Accident · 123 fatalForeign investigationBoeing -737-222 · Arequipa, PeruNTSB LAX96LA123Accident · No injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAthe pilot's improper use of the elevator control, while landing.NTSB SEA96LA065Accident · No injuriesLimited investigationFinal reportNicholson Thorp T18CWS · Grantsville, UTthe pilot's failure to maintain clearance from a powerline. A transmission wire and an oil pressure reading of zero were factors.NTSB LAX96FA122Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Grand Canyon, AZthe failure of the pilot to maintain directional control of the aircraft after landing. Contributing to the accident was the icy runway conditions with poor braking.NTSB ATL96IA056Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Savannah, GAthe copilot's misjudgment of the landing touchdown point, and the pilot-in-command's inadequate supervision.NTSB SEA96LA064Accident · No injuriesLimited investigationFinal reportCessna 180A · Hillsboro, ORthe failure of the pilot to identify the unsuitable taxi area, and the failure of airport maintenance personnel to properly identify a construction area.NTSB FTW96LA135Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARFailure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.NTSB NYC96LA066Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Linden, NJthe pilot's inadequate preflight and failure to follow the checklist to ensure that the fuel selector valve was in the ON position, which resulted in fuel starvation and subsequent loss of engine power. In addition, the pilot failed to maintain airspeed…NTSB LAX96FA121Accident · 3 fatalField investigationFinal reportCessna 172D · Julian, CAthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.NTSB CHI96LA102Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Brighton, IAThe pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.NTSB SEA96LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Jordan, UTimproper installation of the airplane's carburetor fuel lines by maintenance personnel.NTSB NYC96LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Warehouse Point, CTthe pilot's inadequate compensation for the crosswind and gusts. The wind conditions were factors.NTSB MIA96LA087Accident · Serious injuriesLimited investigationFinal reportMarks Kitfox II · Panama City, FLthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…NTSB FTW96LA133Accident · No injuriesLimited investigationFinal reportCessna T210N · Englewood, COthe pilot's inadequate compensation for wind conditions and failure to maintain control of the aircraft during the landing. The adverse wind condition was a related factor.NTSB FTW96LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dewitt, ARa loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA131Accident · No injuriesLimited investigationFinal reportRobinson R22B · Garland, TXFailure of the pilot to maintain sufficient altitude and tail rotor clearance from the terrain, while demonstrating rearward movement in a hover.NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).NTSB DCA96RA042Accident · 4 fatalForeign investigationCessna 337 · Havana, CubaNTSB CHI96LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ILFailure of the student pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the crosswind condition.NTSB CHI96LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · West Chicago, ILthe student pilot's misjudging the flare. A factor was the gusts.NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.NTSB ATL96LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TNthe failure of the pilot of the Cessna 150, N63434, to see and avoid the Cessna 152, N151FC.NTSB ATL96LA054Accident · No injuriesLimited investigationFinal reportCessna 210 · Kinston, NCThe pilot's failure to compensate for the crosswind and his inadequate weather evaluation. A factor was the gusty crosswind.NTSB NYC96LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Bedminster, NJthe pilot's failure to perform a go-around, and his misjudged distance during the landing resulting in the overrun and the subsequent collision with the trees during the aborted landing.NTSB MIA96LA086Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · West Palm Beach, FLFailure of the pilot to maintain adequate altitude/clearance above the water, while performing a low level maneuver (wing over). The pilot's ostentatious display of aerobatic flight was a related factor.NTSB IAD96LA047Accident · No injuriesLimited investigationFinal reportBeech F35 · Mt. Sterling, KYa loss of engine power due to the failure of the number one piston. Related factors were the unsuitable terrain available for the forced landing, and the strong tailwind encountered during the forced landing.NTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.NTSB FTW96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Austin, TXthe partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA058Accident · No injuriesLimited investigationFinal reportBeech 35 · Laurel, MTthe pilot's failure to extend the landing gear. Factors related to the accident were: an inoperative gear warning system, the dark night, and the pilot's failure to follow the checklist.NTSB MIA96IA084Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Miami, FLfailure of the flight engineer to follow the appropriate emergency procedure to manually extend the nose landing gear. Factors relating to the incident were: fatigue failure of the utility hydraulic system relief valve, which resulted in an inoperative normal…NTSB LAX96FA120Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Elk Grove, CAthe pilot's failure to see and avoid the obstruction.NTSB FTW96LA129Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Brownwood, TXthe pilot's failure to follow manufacturer's procedures and premature gear retraction.NTSB FTW96LA128Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Iowa, LAthe pilot's selection of the wrong runway for landing, his delay in initiating a go-around (aborted landing), and his failure to maintain clearance from the transmission lines. Factors relating to the accident were: the pilot's improper weather evaluation,…NTSB FTW96LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Andrews, TXthe mechanic's improper overhaul of the engine. Factors were: the pilot in command's inability to maintain visual lookout due to oil on the windscreen and unsuitable terrain for the forced landing.NTSB CHI96FA095Accident · 1 fatalField investigationFinal reportCessna 310 · Portland, INthe pilot's failure to maintain an altitude adequate for terrain clearance. A factor was the weather.NTSB ATL96LA132Accident · No injuriesLimited investigationFinal reportBeech 35 · Griffin, GAfailure of maintenance personnel to properly balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB ATL96LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Birmingham, ALthe pilot's failure to maintain directional control during landing,