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 LAX94LA167Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Stallion Spring, CAThe pilot's continued VFR flight into instrument meteorological conditions. His failure to obtain a weather briefing, the low clouds, and the mountainous terrain were factors in the accident.NTSB FTW94LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140B · Montrose, COThe pilot's failure to maintain clearance.NTSB FTW94LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Albuquerque, NMThe CFI rated second pilot's failure to maintain the ILS glideslope. A factor was the dark night and lack of supervision.NTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.NTSB CHI94LA112Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 900 · Detroit, MIthe nose landing gear jammed in the UP position due to low pressure in the nose gear strut. A factor associated with the accident is the manufacturer's insufficient standards/requirements for determining the amount of nose strut inflation.NTSB BFO94LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hagerstown, MDThe loss of partial engine power for undetermined reasons.NTSB ATL94T#A01Accident · No injuriesClass 3Final reportde Havilland U6A · Fayetteville, NCNTSB ATL94GA065Accident · Serious injuriesFinal reportConsolidated Aeronautics Lake LA-4-200 · Williamson, GALoss of engine power for an undetermined reason. A factor related to the accident was: improper planning/decision by the flight instructor (CFI).NTSB NYC94LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Norwood, MAThe inadequate supervision by the instructor pilot during the landing, resulting in the improper runway alignment by the student pilot, and the subsequent collision with a snowbank. A factor related to the accident was the incomplete runway snow removal.NTSB LAX94LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Selma, CAThe pilot's improper use of the fuel supply which allowed the engine to sustain fuel starvation, and his failure to follow the emergency checklist by not using the electrical fuel boost pump. The engine fuel starvation was a factor in this accident.NTSB LAX94FA165Accident · 2 fatalField investigationFinal reportAyres S-2R · Reno, NVAn undetermined problem with the engine oil system, a decision to fly the airplane with a known deficiency, and progressive (partial) failure of the engine master rod and bearing.NTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.NTSB FTW94FA101Accident · 4 fatalField investigationFinal reportCessna 172RG · Dulce, NMFailure by the pilot in command to properly plan the flight and calculate performance data.NTSB CHI94IA111Incident · No injuriesIncident investigationFinal reportBeech BE200 · Rochester, INthe airplane painter/refinishers' failure to follow appropriate procedures/directives pertinent to the masking, stripping, painting and cleaning of the airplane cabin windows, which resulted in the in-flight failure of the right aft cabin window. A related…NTSB NYC94LA062Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-61 · Covington, KYThe captain's improper decision to conduct flight at high altitude in an unpressurized airplane, which resulted in his incapacition from depressurization sickness. A factor related to the accident was: maintenance personnel failed to properly secure the…NTSB NYC94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Warfordsburg, PAThe engine failure as a result of a main bearing shift and restricted lubrication, and the lack of suitable terrain for a forced landing.NTSB MIA94WA095Accident · Serious injuriesForeign investigationCessna 402B · Jeremie, HaitiNTSB FTW94LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Lamesa, TXThe inadvertent stall. A factor was the gust of wind.NTSB FTW94FA104Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Battlement Mesa, COImpaired judgement and performance of the pilot by flying while under the influence of alcohol that resulted in his failure to maintain clearance (or altitude) from terrain, while flying at night.NTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.NTSB CHI94LA107Accident · Minor injuriesLimited investigationFinal reportBeech 18S · Kansas City, MOthe failure of the driver of the ground vehicle to exercise proper visual lookout.NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.NTSB ATL94LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Lebanon, TNThe student pilot's failure to follow the flight instructor's instructions to abort the takeoff after the airplane failed to develop takeoff power. The student pilot also delayed in relinquishing the flight control of the airplane to the flight instructor. A…NTSB ATL94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Nashville, TNA loss of engine power for undetermined reasons.NTSB SEA94LA081Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Dubois, IDThe pilot's inadequate visual lookout. Factors include light conditions at dusk.NTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.NTSB FTW94LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hamburg, ARThe loss of engine power due to fouled spark plugs. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94FA062Accident · 1 fatalField investigationFinal reportCessna 152 · Allendale, SCThe pilot's failure to maintain a proper altitude while in the VFR traffic pattern, resulting in a collision with trees. Factors were; his failure to comply with school directives by not obtaining a weather briefing prior to the accident flight, and the rain,…NTSB SEA94LA082Accident · No injuriesLimited investigationFinal reportCessna 185 · Fort Lewis, WAThe fuel shutoff valve seized in a partially open position.NTSB MIA94WA092Accident · Serious injuriesForeign investigationCessna T-337-B · Cay Sal, BahamasNTSB MIA94LA093Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti F-260-C · Opa-Locka, FLThe failure of the pilot-in-command to assure proper positioning of the fuel selector resulting in fuel starvation.NTSB LAX94LA163Accident · No injuriesLimited investigationFinal reportRockwell 681 · Phoenix, AZthe failure of the hydraulic and nitrogen system pressure lines, due to an inadequate maintenance inspection program, which failed to detect the corrosion condition of the lines.NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA094Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Duncan, OKThe pilot's selection of the wrong engine for shut down. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Harbor Springs, MIThe pilot's improper decision to continue flight into icing conditions after the conditions were first encountered. A factor related to the accident was the trees contacted during the landing roll.NTSB MIA94LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sebring, FLThe failure of the muffler in flight for unknown reasons, allowing hot exhaust gasses to impinge on the carburetor igniting the fuel and the subsequent fire.NTSB LAX94LA162Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9-118 · Sedona, AZthe failure of the pilot lights and burners to relight in flight once extinguished due to the installation of an incorrect gas pressure regulator.NTSB LAX94LA161Accident · No injuriesLimited investigationFinal reportLuscombe 8EZ · Prescott, AZthe flying pilot's inadequate compensation for the existing crosswind condition, his failure to maintain directional control, and the inadvertent entry into a ground loop. A factor in the accident was the flying pilot's lack of experience in conventional…NTSB LAX94LA160Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marana, AZThe pilot's delayed pullout from a vertical aerobatic maneuver for undetermined reasons.NTSB LAX94FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Los Angeles, CAthe failure of the upper engine compartment cowl to remain attached to the lower cowl during initial climb as a result of inadequate maintenance and replacement practices by the aircraft owner.NTSB CHI94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Lebanon, INInadequate preflight preparation by the pilot-in-command. Factors were fuel system contamination and an unsuitable terrain encountered by the pilot-in-command during a forced landing.NTSB BFO94WA056Accident · No injuriesForeign investigationCessna C 182 · Tanzania, SudanNTSB ATL94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Columbia, SCThe poor inspection of the aircraft during the annual inspection by maintenance personnel. A factor in the accident was the foreign object found in the carburetor bowl.NTSB ANC94LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Soldotna, AKThe failure of the pilot-in-command/flight instructor to maintain directional control of the airplane.NTSB SEA94LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Seattle, WAThe student's improper flare for landing and the instructor's delayed remedial action.NTSB NYC94LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Beckley, WVA loss of engine power due to fuel contamination, while operating over unsuitable terrain, after the pilot failed to remove all the water from the tank prior to departure. A factor was the pilot's decision to operate the airplane with a known leaking fuel cap.NTSB LAX94LA158Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tacna, AZa catastrophic internal engine failure for undetermined reasons. A factor in the accident was the dark nighttime lighting conditions.NTSB LAX94FA157Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Napa, CAthe pilot's selection of an en route descent altitude profile inadequate to clear all terrain along his intended flight path, and, his inadvertent VFR flight into IMC conditions. Factors in the accident were the dark night lighting conditions and the obscured…NTSB CHI94LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Aurora, NEan inadequate fuel supply for the flight and the pilot's failure to refuel while en route. A factor related to the accident was the soft terrain on which the airplane was landed.NTSB CHI94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ottumwa, SDinadequate compensation for wind conditions and the pilot's failure to maintain directional control. Factors related to the accident were the crosswind and the fence posts.