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 CHI96FA278Accident · 1 fatalField investigationFinal reportLancair 320 · Fond Du Lac, WIthe fatigue in the propeller flange with soft material and oversized lightening holes. A factor was the pilot's inability to maintain control of the aircraft due to the exceeded weight and balance which led to a stall/spin.NTSB ANC96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe airplane's low airspeed during final approach, and the pilot's delayed remedial action in correcting the low airspeed condition.NTSB MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.NTSB LAX96TA298Accident · No injuriesFinal reportBell UH-1H · Ukiah, CAthe commercial/student pilot's improper/abrupt use of aft cyclic during the flare, and the instructor's inadequate supervision of the flight.NTSB IAD96LA129Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Adirondack, NYthe pilot's improper in-flight planning/decision, which resulted in his failure to ensure that he could maintain sufficient altitude and clearance from mountainous terrain after entering a blind canyon. Haze and the terrain were related factors.NTSB FTW96LA345Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Muskogee, OKloss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.NTSB FTW96LA335Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Deer Park, TXloss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and obstructions in the emergency landing area (transmission lines and poles).NTSB FTW96FA337Accident · 2 fatalField investigationFinal reportCulbertson Thorp T-18 · Albuquerque, NMthe pilot's failure to maintain control of the airplane while maneuvering. Factors were the high winds and the high density altitude.NTSB CHI96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rensselaer, INthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA281Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164 · Grant, NEfatigue failure and subsequent catastrophic failure of the number nine cylinder. A factor was the corn.NTSB CHI96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Flushing, MIfuel exhaustion caused by the failure of the pilot to select a fuel tank with fuel remaining.NTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.NTSB SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…NTSB SEA96LA179Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Culbertson, MTthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control; and her inadequate remedial action for gusty winds after the aircraft departed the runway. Factors relating to the accident were: the strong and gusty…NTSB MIA96LA224Accident · No injuriesLimited investigationFinal reportBeech 58 · Panama City, FLfailure of the pilot to extend the landing gear before touchdown, which resulted in an inadvertent wheels-up landing. Factors relating to the accident were: the pilot allowed his attention to be diverted, and the resultant interference with his landing…NTSB MIA96LA205Accident · No injuriesLimited investigationFinal reportHampson Velocity · Dublin, GAthe failure of the exhaust of the cylinder Nos. 2 and 4 at each exhaust flange for undetermined reasons. The unsuitable terrain encountered during the forced landing was a factor.NTSB ANC96LA120Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate compensation for the existing wind conditions. A factor associated with the accident was the windshear.NTSB SEA96LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Astoria, ORfailure of the carburetor heat box flapper valve, and the resultant air flow restriction to the carburetor. A factor relating to the accident was: high vegetation in the area where the forced landing was executed.NTSB SEA96LA177Accident · No injuriesLimited investigationFinal reportCessna U206F · Crane Island, WAthe pilot's failure to correctly judge the surface winds in the vicinity of the runway. Factors relating to the accident were: a tailwind during landing, a short runway with a wet surface, and an embankment/drop-off at the end of the airstrip.NTSB MIA96WA204Accident · Minor injuriesForeign investigationCessna 402B · St. Barthelemy, MartiniqueNTSB LAX96LA297Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Truckee, CAThe pilot's failure to properly compensate for a crosswind component during the go-around in a high density altitude environment that led to a loss of aircraft control..NTSB IAD96LA128Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Amos, Canadathe pilot's inadvertent wheels down landing on water. A related factor was his diverted attention during the landing.NTSB CHI96LA280Accident · No injuriesLimited investigationFinal reportCessna 177B · Drummond Island, MIthe pilot's failure to attain a proper landing attitude, and his failure to recover from the porpoise.NTSB ANC96LA119Accident · No injuriesLimited investigationFinal reportAviat A-1 · King Salmon, AKThe pilot's inadequate weather evaluation, inadequate compensation for the existing wind conditions, and failure to maintain directional control. A factor associated with the accident was the gusty wind.NTSB ANC96FA118Accident · 1 fatalField investigationFinal reportCessna P206 · Nome, AKThe pilot's failure to maintain terrain clearance. Factors include mountainous terrain, low ceilings and mountain obscuration.NTSB MIA96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Live Oak, FLfailure of the pilot to use carburetor heat during the approach to land, which resulted in loss of engine power due to carburetor ice. The weather (carburetor icing condition) was a related factor.NTSB MIA96LA200Accident · 1 fatalLimited investigationFinal reportBell 206B III · Barton, ALfailure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.NTSB LAX96LA307Accident · No injuriesLimited investigationFinal reportCessna A185F · Casa Grande, AZthe student pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop. Factors relating to the accident were: the student pilot's inadequate training and lack of certification (endorsement).NTSB LAX96LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Santa Ana, CAthe pilot's decision to turn off the runway while at an excessive speed that did not allow him to maintain directional control of the aircraft.NTSB LAX96LA296Accident · Serious injuriesLimited investigationFinal reportCessna 421C · Avalon, CAthe pilot's failure to initiate a go-around when a landing overshoot became apparent. Factors which contributed to the accident were: the pilot's excessive airspeed and misjudged distance during landing, his lack of flying experience in the Cessna, and…NTSB IAD96LA125Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHfailure of the student pilot to maintain sufficient airspeed during an attempted go-around, which resulted in a stall/spin and an uncontrolled collision with the ground. A factor related to the accident was: an improper (premature) flare for landing.NTSB IAD96LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Waverly, OHthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) with subsequent loss of visual contact and collision with the ground. Darkness and fog were related factors.NTSB IAD96FA126Accident · 1 fatalField investigationFinal reportAerotek Pitts Special S-1S · Pittsburgh, PAThe pilot's utilization of airspeeds greater than the manufacturer recommended maneuvering airspeeds which exceed the design limits of the airplane and resulted in the subsequent failure of the wing spar.NTSB FTW96LA336Accident · No injuriesLimited investigationFinal reportBeech E-55 · Brownwood, TXThe pilot's failure to extend the landing gear. Factors were the pilot's failure to use a checklist, his diverted attention, and the landing gear warning horn not sounding.NTSB FTW96LA333Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Clayton, LAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the wet grass runway.NTSB FTW96LA332Accident · No injuriesLimited investigationFinal reportAyres S2R-G5 · Start, LAa leak in the turbine scavenge pump oil supply line, due to chafing of its separated shield assembly, which resulted in an oil leak, oil starvation, and activation of the propeller feathering system.NTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.NTSB CHI96LA272Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Poseyville, INthe pilot's improper flare during the landing. A factor relating to the accident was: the pilot's lack of familiarity with the make and model of airplane.NTSB CHI96LA270Accident · Minor injuriesLimited investigationFinal reportGeide SPORT-A · Slater, MOfailure of a #2 connecting rod bolt, which led to a jammed connecting rod and subsequent overload separation of the #2 cylinder. A factor relating to the accident was: lack of suitable terrain for an emergency landing.NTSB ANC96LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's improper approach to landing, and his delay in initiating a go-around.NTSB ANC96LA111Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas MD369D · Healy, AKThe inadequate visual outlook by the pilots of both aircraft, and their failure to see and avoid the other aircraft. A factor associated with the accident was sunglare affecting the helicopter pilot's vision.NTSB SEA96LA176Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Belgrade, MTloss of engine power for undetermined reason(s). A factor relating to the accident was: a ditch in the field where the forced landing was executed.NTSB NYC96LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sodus, NYThe pilot's failure to obtain the proper touchdown point, which resulted in insufficient runway to stop the airplane, and the subsequent overrun. Factors in the accident were the wet grass runway surface, and the pilot's lack of recent flying experience.NTSB NYC96LA161Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Pittsburgh, PAThe pilot's failure to maintain alignment with the runway, and his failure to maintain control of the airplane during the aborted landing, which resulted in the inadvertent stall/mush, and collision with the runway.NTSB MIA96LA201Accident · Serious injuriesLimited investigationFinal reportHernandez Challenger Special II · Toa Baja, PRwater contamination in the fuel system, which resulted in a partial loss of engine power shortly after takeoff. Factors relating to the accident were: the lack of a quick draining feature in the fuel system, the pilot's failure (or inability) to detect water…NTSB LAX96LA295Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Douglas, AZThe pilot's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the pilot's inexperience in the type aircraft.NTSB IAD96LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, OHThe pilot's failure to attain adequate alignment with the runway and to maintain adequate terrain clearance during landing.NTSB FTW96LA334Accident · No injuriesLimited investigationFinal reportCessna 210 · Pueblo, COimproper routing of the nose landing gear hydraulic line by unknown maintenance personnel, allowing it to chafe on the nose wheel and develop a leak, which resulted in an inability to obtain a down-and-locked condition of the landing gear.NTSB FTW96LA330Accident · No injuriesLimited investigationFinal reportSchleicher KA6-CR · Forrest City, ARthe pilot's failure to abort the takeoff. Factors were the dust restricting his visibility and the uneven terrain.