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 BFO90FA064Accident · Serious injuriesField investigationFinal reportPiper PA-28-200 · Baltimore, MDThe pilot failed to maintain adequate airspeed which resulted in a stall. Contributing was the loss of power for undetermined reasons.NTSB ANC90LA121Accident · No injuriesLimited investigationFinal reportCessna 150M · Goose Bay, AKA loss of engine power for undetermined reasons. The wet tundra was a contributing factor.NTSB ANC90LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Bettles, AKPilot-in-command's failure to attain airspeed during takeoff.NTSB NYC90LA166Accident · No injuriesLimited investigationFinal reportCessna 150M · New Knoxville, OHThe pilot's improper use of flight controls which resulted in loss of directional control during the takeoff ground run.NTSB MIA90LA155Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Fort Myers, FLUnforecasted encounter with weather. The airplane encountered severe turblence during enroute descent, resulting in one flight attendant sustaining serious injury, and one passenger sustaining minor injury.NTSB LAX90LA259Accident · No injuriesLimited investigationFinal reportCessna 421C · Lancaster, CAThe accident was eroded ignition spark plug electrodes and maintenance personnel neglecting to adjust spark plug electrodes and maintenance personnel neglecting to adjust spark plug gap. The rough terrain in which the aircraft landed was a factor in the…NTSB DEN90LA165Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Cheyenne Wells, COThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to compensate for the existing cross wind.NTSB CHI90LA189Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Milwaukee, WIThe pilot's delayed determination of traction or braking action until too little runway remained to go around or to employ alternate means of activiating the brakes. Contributing to the accident was the overservicing of the main gear struts.NTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.NTSB CHI90DER02Accident · 2 fatalFinal reportNorth American P-51D · Mayer, MNUndeterminedNTSB ATL90DMG03Accident · No injuriesFinal reportPiper PA-25 · Farmville, NCThe pilot's inadequate pre-flight preparation when he declined to add fuel between aerial application flights. The engine quit as a result of fuel exhaustion.NTSB ANC90LA119Accident · No injuriesLimited investigationFinal reportBell 206B · Goodnews Bay, AKThe pilot selected unsuitable terrain. The wet & soft tundra was a factor.NTSB SEA90LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Klamath Falls, ORPilot's failure to maintain directional control during the landing roll, resulting in a ground loop. The pilot's lack of experience in this make/model was a related factor.NTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.NTSB MIA90LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeland, FLThe improper use of the carburetor heat control resulting in the loss of engine power due to carburetor ice.NTSB SEA90LA137Accident · No injuriesLimited investigationFinal reportSikorsky S-58BT · Ovando, MTThe pilot did not maintain rotor RPM after a compressor assembly blade failure. A related factor was an inadequate autorotation resulting in a hard landing.NTSB NYC90LA163Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Wilmington, OHA power loss caused by fuel exhaustion when the pilot took off with the fuel selector on the empty fuel tank.NTSB NYC90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Radnow Township, PAWire strike during an off airport forced landing in unsuitable terrain. Contributing factors were a power loss, caused by an engine oil leak.NTSB MKC90LA149Accident · No injuriesLimited investigationFinal reportCessna 177 · Newton, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB LAX90LA258Accident · No injuriesLimited investigationFinal reportCessna 340-A · Truckee, CAThe pilots loss of brake performance due to hydroplaning.NTSB FTW90DPG03Accident · No injuriesFinal reportGrumman G164-A · Rondo, ARThe power loss for undetermined reasons.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB CHI90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Moorhead, MNThe pilot's poor in-flight planning and fuel system monitoring, and his failure to maintain directional control during the subsequent forced landing.NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB SEA90LA138Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Darrington, WAThe inflight encounter with turbulent downdraft winds that resulted in a vertical descent from which the pilot could not recover with full power applied.NTSB NYC90LA161Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Doylestown, PAA loss of engine power due to an inoperable carburetor heat control. Lack of suitable terrain for the forced landing was a factor.NTSB NYC90LA159Accident · No injuriesLimited investigationFinal reportCessna 310R · Hyannis, MAA hard landing due to the pilot stalling the airplane during the landing flare. Contributing to this accident was gusty wind conditions.NTSB MKC90LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Columbia, MOAircraft control not maintained resulting in a stall/mush by the PIC.NTSB FTW90FA141Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Garfield, COThe pilot's decision to fly into the mountain pass and the subsequent inability to maintain adequate ground clearance.NTSB CHI90LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, SDThe pilot in command's improper in flight planning which resulted in fuel exhaustion and a forced landing in a field at which time the aircraft nosed over.NTSB CHI90LA175Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Tecumseh, MIA loss of engine power due to unknown reasons.NTSB CHI90LA172Accident · No injuriesLimited investigationFinal reportLearjet LR-24D · Benton Harbor, MIPilot-in-command's misjudged approach to landing, which resulted in the aircraft running off the departure end of the runway into a ravine. The late, dark night, IFR conditions contributed to the accident.NTSB ATL90LA147Accident · No injuriesLimited investigationFinal reportBeech 23 · Stone Mountain, GAThe pilot's improperly planned approach, in that the airplane was high and fast, which resulted in the runway overrun.NTSB ATL90LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fort Payne, ALThe pilot's selection of a runway which afforded a tailwind, and his improper use of the elevator control during the landing roll.NTSB ATL90FA145Accident · Serious injuriesField investigationFinal reportCessna 340 · Atlanta, GAThe pilot-in-command's inadequate fuel management, in that he did not select main fuel tanks prior to this approach. This resulted in fuel starvation to the engines, and the subsequent loss of all engine power.NTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.NTSB ANC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Moller, AKThe pilot failed to maintain directional control during landing. Contributing to the accident were the unfavorable winds, the soft runway surface, and the pilot's lack of training and total experience.NTSB SEA90LA136Accident · No injuriesLimited investigationFinal reportNorth American P-51 · Seattle, WAAn encounter with vortex turbulence while on final approach to landing.NTSB NYC90LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Shirley, NYThe pilot's lack of qualifications, the improper use of flight controls, the second pilot's lack of qualifications, and his decision to simulate the engine failure.NTSB NYC90LA160Accident · 1 fatalLimited investigationFinal reportCessna U206F · Augusta, MEImproper planning/decision by the pilot, and his failure to compensate for wind conditions. The unfavorable wind conditions and rough water were related factors.NTSB NYC90LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Liverpool, OHThe pilot in command's failure to detect contaminated fuel by draining the fuel system prior to takeoff resulting in engine failure and a forced landing.NTSB MIA90LA153Accident · No injuriesLimited investigationFinal reportLockheed L-188A · Caribbean SeaThe inflight loss of the nos 3 and 4 propellers and gearboxes for undetermined reasons. The failed components were not recovered from the Caribbean Sea.NTSB MIA90LA152Accident · Serious injuriesLimited investigationFinal reportBoeing 747-136 · Miami, FLThe inadvertent encounter with severe turbulence while operating in an area of thunderstorm activity.NTSB LAX90LA257Accident · No injuriesLimited investigationFinal reportCessna A185F · Discovery Bay, CAThe pilot's improper visual lookout to assure the area was clear of boats before departing.NTSB LAX90DUG08Accident · 2 fatalFinal reportSelstad VARI-EZE · Corona, CAThe failure of the pilot to maintain control of the aircraft. Factors related to the accident were: the pilot's lack of experience in the type of aircraft, his impairment from consumption of alcohol, and inadequate altitude to recover from the loss of control.NTSB FTW90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Houston, TXStudent pilot's failure to maintain directional control during landing.NTSB DEN90LA164Accident · No injuriesLimited investigationFinal reportMooney M20F · Torrington, WYA partial loss of power due to a failed exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB CHI90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Webster, WIThe failure of the nose gear transmission mounting bracket which resulted in nose gear collapse during the landing roll.NTSB CHI90LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Grand Marais, MNUndetermined partial loss of engine power during the initial climbout. A factor was the lack of suitable terrain for a forced landing.NTSB CHI90FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Marais, MNPoor judgement of the pilot due to his impairment from consumption of alcohol, and his failure to maintain control of the aircraft. A factor related to the accident was: pilot fatigue due to lack of sleep.