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 BFO93LA142Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Matawan, NJThe water collection in the ignition harness which rendered the lower cylinder spark plugs inoperative resulting in partial power loss.NTSB ANC93LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's failure to maintain directional control of the airpalne. A factor in the accident was the ditch along the side of the runway.NTSB ANC93LA130Accident · 2 fatalLimited investigationFinal reportCessna 170 · Dry Bay, AKUndetermined.NTSB SEA93LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monroe, WAThe improper inflight decision by the PIC and his failure to attain proper runway alignment. Factors relating to the accident were the dark night light conditions, unavailability of runway lights, and lack of recent night flight time by the PIC.NTSB LAX93LA307Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Santa Margarita, CAthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB LAX93LA306Accident · No injuriesLimited investigationFinal reportAyres S-2R-T34 · Tulare, CAthe failure of the main gear inner lower tube assembly due to fatigue.NTSB DEN93FA090Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elk Springs, COThe performance of a stall/spin at an altitude inadequate for recovery and level off.NTSB CHI93LA306Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Liberty, MOThe pilot's failure to maintain adequate aircraft control during the emergency landing. A factor is the pilot's lack of experience in the aircraft.NTSB CHI93LA282Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brule, NEThe unsuitable terrain encountered. Factors relating to this accident include total failure of an engine cylinder, and a hidden obstruction.NTSB ATL93LA137Accident · 1 fatalLimited investigationFinal reportWard Long EZE · Murfreesboro, TNThe pilot's failure to properly use the carburetor heat control which resulted in the formation of carburetor ice.NTSB LAX93T#A06Accident · No injuriesClass 3Final reportBell 206B3 · Pine, AZNTSB LAX93LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight, the improper recovery from the bounced landing by the crew, and the lack of total experience in giving dual instruction by the CFI. Factors which contributed to this accident were: the dual student's improper…NTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.NTSB LAX93LA302Accident · No injuriesLimited investigationFinal reportRobinson R22-B · Venice, CAThe failure of the pilot to maintain proper main rotor RPM, altitude, and airspeed during the performance of a steep turn. Inadequate in-flight planning and overconfidence in the pilot's abilities were factors in this accident.NTSB DEN93LA088Accident · Serious injuriesLimited investigationFinal reportPiper J3C-90 · Meeker, COFailure of the pilot to maintain adequate terrain clearance. A factor was the intentional low pass performed by the pilot in command.NTSB CHI93LA294Accident · No injuriesLimited investigationFinal reportNorth American F-51 · Fond Du Lac, WIthe pilot-in-command of the F-51's diverted attention and failure to maintain a visual outlook.NTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.NTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.NTSB CHI93LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Troy, MIIs the pilot not attaining the proper touchdown point, not flying a proper glidepath, and not performing a go around.NTSB BFO93LA140Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Woodbine, NJThe pilot maintaining too steep of an angle of climb and an inadequate airspeed which resulted in an inadvertent stall/mush and subsequent loss of control in flight resulting in a collision with the runway. The pilot's lack of experience in the type of…NTSB ATL93FA136Accident · Serious injuriesField investigationFinal reportCessna 172M · Harvest, ALThe pilot's poorly planned approach and the failure of the pilot to execute a go-around.NTSB SEA93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Dayton, WAThe loss of engine power, undetermined. A factor relating to the accident was a fence in the flt path.NTSB SEA93LA165Accident · No injuriesLimited investigationFinal reportRiches Avid Flyer · Tooele, UTThe failure of the PIC to maintain directional control and to correct a ground loop/swerve.NTSB SEA93LA164Accident · No injuriesLimited investigationFinal reportChampion 7EC · Chewelah, WAThe failure of the PIC to maintain directional control and correct for ground loop/swerve.NTSB SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.NTSB FTW93LA219Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Vidor, TXControl cable separation due to the throttle power lever linkage not being secured by retainer resultant from improper installation. A factor was a lack of suitable terrain for the forced landing.NTSB FTW93LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · League City, TXVisual lookout not maintained by the driver of the vehicle. A factor was the driver of the vehicle becoming inadvertently lost.NTSB DEN93LA087Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Wray, COThe pilot's inadequate compensation for the wind conditions and improper recovery from a bounced landing. The gusty crosswind was a factor.NTSB DEN93FA089Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Durango, COThe pilot's entry into a box canyon at an altitude insufficient to clear mountainous terrain.NTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.NTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.NTSB CHI93LA288Accident · No injuriesLimited investigationFinal reportMurphy Rebel · Pickett, WIThe pilot's inadequate preflight planning which resulted in fuel exhaustion. The lack of suitable terrain for a forced landing was a factor in the accident.NTSB CHI93LA287Accident · No injuriesLimited investigationFinal reportCessna T210M · Neosho, MOIs the pilot in command's failure to maintain proper clearance. Factors relating to this accident are the pilot in command's inadequate preflight preparation and the loss of total engine power as a result of fuel exhaustion.NTSB CHI93LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crookston, MNThe pilot in command's delayed in-flight decision. A factor to the accident is the pilot in command's failure to attain a proper touchdown point.NTSB ATL93IA135Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Charleston, SCWas the pilot's failure to maintain adequate airspeed during the landing attempt which resulted in a stall and the subsequent collision with the runway.NTSB ANC93FA128Accident · No injuriesField investigationFinal reportConvair 240 · Boise, IDThe pilot's failure to extend the landing gear, and the check pilot's inadequate supervisiion. A factor in the accident was the pilot's inadequate upgrade training by the company.NTSB SEA93LA161Accident · No injuriesLimited investigationFinal reportBell B206BII · Lake Powell, UTA power loss for undetermined reasons. Factors include landing in water.NTSB MIA93T#A02Accident · No injuriesClass 3Final reportHughes 369E · Carolina, PRNTSB MIA93LA165Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Columbus, MSThe pilot-in-command's improper decision to turn the fuel selector off prematurely during his attempted landing.NTSB LAX93LA301Accident · Minor injuriesLimited investigationFinal reportFerdon Thorp S-18 · Ash Fork, AZThe pilots inadequate compensation for wind conditions and failure to maintain directional control of the airplane during a precautionary landing, that resulted in collision with a fence and nose over of the airplane. A cross wind condition was a factor in…NTSB LAX93FA377Accident · 3 fatalField investigationFinal reportBeech F33A · Baker, CAA loss of control for undetermined reason(s).NTSB LAX93FA300Accident · 6 fatalField investigationFinal reportCessna 310H · Lancaster, CAthe pilot's improper in-flight planning/decision and his failure to maintain the minimum control airspeed which progressed to an inadverent stall/spin. Factors relating to this accident were fuel exhaustion and the pilot's lack of experience in the accident…NTSB CHI93MA276Accident · 3 fatalMajor investigationFinal reportCanadair CL-600-2B19 · Byers, KSThe captain's failure to adhere to the agreed upon flight test plan for ending the test maneuver at the onset of prestall stick shaker, and the flightcrew's failure to assure that all required switches were properly positioned for anti-spin chute deployment.…NTSB CHI93LA286Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Birmingham, MIAn improper grade of fuel was loaded into the airplane by the owner/operator of the rental airplane, improper planning and/or decision by the pilot, and subsequent vapor lock in the fuel system of the airplane (fuel system - other), which resulted in fuel…NTSB CHI93LA284Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbus, INthe pilot in command's failure to maintain proper clearance. A factor involved in this accident is the pilot in command's failure to maintain a proper glidepath.NTSB CHI93LA278Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · West Plains, MOThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB NYC93FA137Accident · No injuriesField investigationFinal reportBoeing 747-368 · Jamaica, NYMissjudged clearance by the captain of the B-747, hz-ais, as he attempted to maneuver around the ATR-42, N242AT. A factor related to the accident was the diverted attention of the captain of the B-747.NTSB MIA93LA164Accident · Serious injuriesLimited investigationFinal reportMaxair AVR-582 · Wimauma, FLThe pilot-in-commands failure to maintain airspeed while making a forced landing following loss of engine power resulting in the aircraft stalling and descending uncontrolled to the ground.NTSB MIA93FA163Accident · 3 fatalField investigationFinal reportBeech C23 · St Petersburg, FLFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's lack of familiarity with the airport, and his selection of the wrong runway.NTSB LAX93LA363Accident · No injuriesLimited investigationFinal reportCessna 210A · Salinas, CAAn undetermined loss of engine power during the final approach phase of landing resulting in a collision with terrain during the forced landing.