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 ENG07WA010Incident · No injuriesForeign investigationBoeing 767-300ER(F) · Auckland, New ZealandNTSB DFW07WA054Accident · 2 fatalForeign investigationSabreliner NA-265T39 · Culiacan, MexicoNTSB DFW07CA050Accident · No injuriesData collectionFinal reportHughes 269C · Mineral Wells, TXThe loss of control as result of loss of tail rotor effectiveness.NTSB ANC07CA010Accident · Minor injuriesData collectionFinal reportBeech BE-23 · Asheville, NCThe pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in a forced landing and collision with trees. Factors associated with the accident were fog and low ceilings.NTSB SEA07LA039Accident · Serious injuriesLimited investigationFinal reportAveryt Vans RV-4 · Grants Pass, ORThe pilot's failure to maintain adequate airspeed during performance of a go-around, resulting in an inadvertent stall and subsequent in flight collision with the ground. A contributing factor was the in-flight loss of a portion of one propeller blade.NTSB DEN07WA041Accident · 1 fatalForeign investigationPiper PA-28-161 · Cantal Region, FranceNTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.NTSB DCA07WA018Incident · No injuriesForeign investigationBoeing 737-400 · Medan, IndonesiaNTSB CHI07LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-260B · Belleville, ILThe failure of the torque link bolt which resulted in the right main landing gear strut scissors separating and becoming jammed in the wheel well. Contributing to the accident was the seized torque link bolt due to surface corrosion.NTSB LAX07LA065Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lake Hughes, CAThe pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.NTSB LAX07LA064Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · San Diego, CAFailure of the captain of the other taxiing airplane to maintain clearance from an occupied airplane stopped on the ramp.NTSB LAX07CA066Accident · Minor injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe flight's encounter with a low ceiling while on approach that necessatiated an off-airport precautionary landing on unsuitable terrain. Obstructions were a factor.NTSB DFW07LA056Accident · No injuriesLimited investigationFinal reportCessna 172S · Tulsa, OKThe pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.NTSB DFW07CA046Accident · No injuriesData collectionFinal reportCessna 172M · Houston, TXThe pilot's failure to compensate for the existing wind conditions during the landing roll resulting in a loss of control. A contributing factor was the crosswind.NTSB DFW07CA045Accident · No injuriesData collectionFinal reportErcoupe 415-C · Lakeshore, MSThe landing overrun for unknown reasons. A factor was the ditch.NTSB DFW07CA044Accident · No injuriesData collectionFinal reportCessna 150M · Eastland, TXThe partial loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and an overrun. A factor associated with the accident was the pilot's misjudged distance/speed while landing.NTSB CHI07FA048Accident · 2 fatalField investigationFinal reportMooney M-20F · Mt. Gilead, OHBoth the pilot-in-command/aircraft owner and the flight instructor failed to recover from the stall and the flight instructor's inadequate supervision of the flight. Contributing to the accident was the failure to maintain stall speed which resulted in the…NTSB CHI07CA047Accident · Minor injuriesData collectionFinal reportCessna T210L · North St. Louis, MOFuel starvation due to an inadequate fuel supply. A factor associated with the accident was the soft terrain encountered during the landing.NTSB NYC07FA051Accident · 2 fatalField investigationFinal reportCessna 414 · Johnstown, PAThe pilot's improper decision to abort the landing with a damaged airplane. Contributing to the accident were the damage from the airplane's impact with the runway, the pilot's failure to lower the landing gear prior to the landing attempt, and the in-flight…NTSB MIA07IA031Incident · No injuriesIncident investigationFinal reportBoeing 747-436 · Miami, FLThe flightcrew's misinterpretation of available lighting, signage, and airfield marking cues during taxi.NTSB CHI07FA046Accident · 2 fatalField investigationFinal reportRockwell International 114 · Jasper, TNThe pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB ANC07LA009Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Nashville, TNThe pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…NTSB DEN07CA039Accident · No injuriesData collectionFinal reportCessna T210M · Broomfield, COthe failure of the mechanic to comply with the required replacement schedule resulting in the failure of the hydraulic line and the resulting gear up landing.NTSB MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB DEN07CA043Accident · No injuriesData collectionFinal reportCessna 172N · Cottonwood Fall, KSthe pilot's failure to maintain clearance from the fence. Contributing to the accident was the pilot's inability to properly identify the runway environment, and the improper in-flight decision to initiate a go-around.NTSB DCA07WA017Accident · No injuriesForeign investigationBoeing B737-400 · Makassar, IndonesiaNTSB ANC07LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-228F · Anchorage, AKThe failure of the deicing truck crew to maintain sufficient distance from the parked airplane during deicing, which resulted in a collision and substantial damage to the airplane.NTSB LAX07CA063Accident · No injuriesData collectionFinal reportBelcher Helicycle · Boulder City, NVa loss of engine power due to a fractured fuel line.NTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.NTSB CHI07CA049Accident · No injuriesData collectionFinal reportBeech 99 · Mosinee, WIThe pilot encountering the unsuitable terrain during the landing. Factors were the dark night and the snowbank.NTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.NTSB MIA07FA029Accident · 5 fatalField investigationFinal reportCessna 421B · Greenhead, FLThe pilot-in-command's improper planning/decision and continued flight into known adverse weather which resulted in an encounter with a level 5 thunderstorm.NTSB LAX07FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bridgeport, CAThe pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.NTSB ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.NTSB SEA07LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fresno, CAThe design stress limits of the airframe were exceeded by an unknown pilot.NTSB SEA07LA037Accident · Minor injuriesLimited investigationFinal reportCavalier F51D Mustang · Rexburg, IDThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB MIA07LA032Accident · Minor injuriesLimited investigationFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe airplane manufacturer's inadequate maintenance prior to final aircraft delivery, which resulted in fuel filter blockage and engine fuel starvation.NTSB LAX07LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZa loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.NTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.NTSB LAX07FA059Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Concord, CAFailure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.NTSB DFW07LA043Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Grand Prairie, TXThe flight instructor's inadequate remedial action which resulted in a hard landing. A contributing factor was the lack of suitable terrain for the practice autorotation.NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.NTSB LAX07FA062Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Young, AZThe pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…NTSB DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB DFW07FA041Accident · 1 fatalField investigationFinal reportBeech A36 · Fayetteville, ARThe pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.NTSB SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.NTSB CHI07LA043Accident · No injuriesLimited investigationFinal reportCessna 560 · North Canton, OHThe rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…NTSB CHI07FA041Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Bucyrus, OHThe inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…NTSB SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.