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 CHI89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Ypsilanti, MIThe failure of the plt to maintain directional control during the takeoff ground roll. Rain softened terrain adjacent to the runway surface is a contributing factor to the accident.NTSB CHI89LA185Accident · No injuriesLimited investigationFinal reportCessna C172R · Frankenmuth, MIThe pilot's failure to maintain control of the aircraft during takeoff as a result of a diversion of attention due to a possible engine problem.NTSB BFO89LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Haymarket, VAImproper use of the fuel selector, which resulted in fuel starvation & loss of engine power; and improper use of emergency procedures after loss of engine power. The presence of high obstructions (trees) in the approach path to the emergency landing area was…NTSB ATL89LA215Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Semmes, ALImproper replacement of the fuel cap gasket by the pilot, which resulted in a blocked fuel cap vent and fuel starvation. Trees in the emergency landing area contributed to aircraft damage.NTSB ATL89FA214Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Gordon, ALThe improper installation of the fuel gascolator bowl by maintenance personnel, which resulted in fuel leakage and a loss of fuel pressure to the engine.NTSB MIA89LA251Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yulee, FLImproper planning/decision by the student pilot. Factors related to the accident were: the adverse weather conditions and the tree and ditch in the emergency landing area.NTSB LAX89FA304Accident · 2 fatalField investigationFinal reportRockwell 112B · La Grange, CAContinued VFR flight into instrument meteorlogical conditions (IMC) by the pilot, which resulted in spatial disorientation and loss of aircraft control. Related factors were: flight into known adverse weather by the pilot, the adverse weather conditions, and…NTSB FTW89WA175Accident · No injuriesForeign investigationBell 206L-1 · Molongo, AngolaNTSB FTW89FA166Accident · Serious injuriesField investigationFinal reportBeech BE 100 · Houston, TXThe inadequate preflight planning preparation & the improper inflight planning/decision by the PIC when he failed to refuel the aircraft which resulted in a total loss of power in both engines.NTSB FTW89DRG10Accident · 1 fatalFinal reportZenair CH-200 · Kerrville, TXImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB DEN89LA210Accident · 1 fatalLimited investigationFinal reportLet L-13 · Buena Vista, COA premature release of the glider tow line by the glider pilot and his failure to maintain sufficient airspeed, while maneuvering back toward the runway, which resulted in an inadvertent stall.NTSB CHI89LA187Accident · No injuriesLimited investigationFinal reportCessna 120 · Shelbyville, INThe pilot failed to maintain proper alignment during the landing roll.NTSB ATL89FA213Accident · 6 fatalField investigationFinal reportBeech 100 · Mayfield, KYFailure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness, the adverse weather conditions, and the tree.NTSB SEA89LA173Accident · 1 fatalLimited investigationFinal reportMiller Special JM-2 · Reno, NVStructural failure when design stress limits were exceeded after encountering hazardous meteorological conditions.NTSB MKC89LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Barnesville, MNThe pilot's failure to insure that the aircraft contained an adequate fuel supply to complete the flight.NTSB MIA89LA250Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLThe private pilot's failure to maintain airspeed on final approach, which resulted in a stall/mush. The turbulence was a related factor.NTSB LAX89FA314Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Ontario, CAFailure of the right propeller hub due to metal fatigue which resulted in catastrophic separation of the propeller. Contributing to the accident was damage done to the aircraft airframe in flight by the separating propeller making the aircraft uncontrollable.NTSB FTW89IA168Incident · No injuriesIncident investigationFinal reportCessna 152 · Bethany, OKFailure of the Cessna 150 pilot to see-and-avoid the Cessna 152 (inadequate visual lookout), and failure of the tower controller to provide adequate service. Factors related to the accident were: high traffic density, which resulted in frequency congestion,…NTSB DEN89FA217Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Louisville, COFailure of the pilot to maintain adequate airspeed, while maneuvering for spacing in the traffic pattern, which resulted in an inadvertent stall at low altitude.NTSB CHI89LA184Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Columbus, INThe co-pilot's failure to relinquish control of the aircraft to the pilot-in-command after encountering directional control difficulties during roll-out, and excessive braking by the co-pilot.NTSB ATL89LA212Accident · No injuriesLimited investigationFinal reportSikorsky H-34J · Louisville, GAAn undetermined malfunction of the main rotor drive system.NTSB ANC89LA165Accident · No injuriesLimited investigationFinal reportCessna U206 · Nondalton, AKFailure of the pilot to attain the proper touchdown point for the landing, his excessive airspeed, and his misjudgement of runway distance remaining. Factors related to the accident were: loose/wet gravel on the runway and the location of the parked aircraft…NTSB SEA89LA172Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Hillsboro, ORThe pilot misjudging altitude and airspeed.NTSB LAX89LA312Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Paula, CAImproper in-flight planning/decision by the student pilot. Contributing factors were the parked aircraft, hangar, and the student pilot's lack of total experience.NTSB LAX89DUJ10Accident · Serious injuriesFinal reportAyres S-2R · Yuma, AZThe failure of the pilot to maintain directional control after landing on a dry gravel runway.NTSB DEN89LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot failed to maintain the proper glidepath during a practice instrument approach resulting in a collision with terrain. Contributing factor(s) was: the dark night light condition.NTSB CHI89TL#05Accident · No injuriesClass 3Final reportBeech D45 (T-34B) · Gaylord, MINTSB ANC89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Stony River, AKPilot's failure to ensure that his landing area was properly clear prior to landing.NTSB MIA89IA249Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · Fort Pierce, FLThe student's failure to maintain directional control of the airplane. Contributing to the accident was the student's lack of experience.NTSB MIA89IA248Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLImproper use of the elevator control.NTSB MIA89IA247Incident · No injuriesIncident investigationFinal reportBeech G18S · Jackson, MSFailure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.NTSB LAX89FA311Accident · Serious injuriesField investigationFinal reportCessna 152 · Buena Park, CAAn inadequate performed preflight inspection by the dual student and the inadequate supervision of the dual student by the instructor pilot. Contaminated fuel was a factor in the accident.NTSB LAX89DVA10Accident · No injuriesFinal reportAir Tractor AT-301 · Mendota, CAA loss of aircraft control by the pilot when he slowed the aircraft to begin a spray run. Contributing to the loss of control was the inoperative stall warning system.NTSB MIA89LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Marathon, FLThe pilot's misjudgement of clearance between his aircraft and the parked aircraft. Factors related to the accident were: sunglare and the location of the parked aircraft.NTSB DEN89LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Winston, NMDeteriorated carburetor float. Factors related to the accident were: high density altitude and the terrain conditions in the emergency landing area.NTSB CHI89FA183Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-80 · Chicago, ILA loss of hydraulic system pressure due to the operator's failure to replace a system component that had a known history of failures, and the pilot's improper use powerplant controls resulting in a degradation of rudder effectiveness. A contributing factor…NTSB ANC89LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Trading Bay, AKThe pilot selected unsuitable terrain for his intended landing area. Wet terrain/hydroplaning conditions in the initial touchdown area and an object (stump) contributed to the occurrence.NTSB SEA89LA171Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 11 · Reno, NVThe right main landing gear did not fully extend for an undetermined reason. Factors that contributed to the accident were: an engine power loss for unknown reasons and the rough terrain.NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB MKC89FA196Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bentonville, ARA loose oil line that became disconnected, when maintenance/inspection of the aircraft had not been completed, which resulted in loss of engine oil and subsequent failure of the connecting rod from lack of lubrication. A factor related to the accident was:…NTSB LAX89LA308Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAThe pilot's failure to maintain directional control during landing roll-out, which resulted a ground swerve. The pilot's relatively low level of flying experience and the berm beside the runway were related factors.NTSB LAX89FA307Accident · 1 fatalField investigationFinal reportAero Commander 680FLP · Kailua-Kona, HIInadequate maintenance, and operation by the pilot with known deficiencies in the aircraft. Factors related to the accident were: excessive wear in both engines, improper use of powerplant controls by the pilot, subsequent overtemperature/detonation in both…NTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.NTSB CHI89LA182Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Newark, ILInadequate supervision by the flight instructor (CFI) and his delay in aborting the takeoff. Factors related to the accident were: malfunction of the flap system, which resulted in an improper flap setting for takeoff, and the soft runway condition.NTSB ANC89LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle City, AKPilot failed to maintain directional during the landing roll.NTSB ANC89LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wood River, AKInnadequate preflight planning/preparation by the pilot. The wind conditions, high density altitude and trees were contributing factors.NTSB SEA89LA168Accident · No injuriesLimited investigationFinal reportCessna R182 · Jordan Valley, ORFailure of the pilot to maintain directional control. Factors related to the accident were: the pilot's selection of unsuitable terrain (closed/rough runway), and the crosswind.NTSB NYC89DHM05Accident · Minor injuriesFinal reportWoods Formula VEE SL-1 · Allaire Airport, NJThe improper flare and touchdown by the pilot in command while making a forced landing following loss of engine power.NTSB MIA89LA245Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLInadequate visual lookout by the Waco pilot, which resulted in his misjudgement of clearance between his aircraft and the Cessna 172 and a subsequent collision.NTSB MIA89LA244Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Titusville, FLFailure of the private pilot (dual student) to assure the fuel selector was positioned to the proper tank, which resulted in fuel starvation; and inadequate supervision by the instructor pilot (CFI). The trees were a related factor.