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 CHI96LA024Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Liberal, KSthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control and an inadvertent ground swerve.NTSB BFO96LA019Accident · No injuriesLimited investigationFinal reportCessna T210L · College Park, MDthe pilot's improper recovery from a bounced landing and his failure to initiate a go-around. Related factors were the crosswind and the pilot's concern about being late for meetings he had scheduled.NTSB SEA96FA010Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Alta, WYthe corrosion, consequent fatigue cracking and ultimate separation of the right wing forward lift strut.NTSB MIA96FA013Accident · No injuriesField investigationFinal reportBoeing 747-121 · Miami, FLfailure of the No. 4 engine fifth stage turbine hub due to a cyclic stress rupture for undetermined reasons, which resulted in an uncontained failure of the engine.NTSB NYC96LA017Accident · No injuriesLimited investigationFinal reportCessna 182B · Lebanon, MEthe pilot's improper use of the mixture control which resulted in fuel starvation and loss of engine power.NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…NTSB FTW96TA021Accident · No injuriesFinal reportBeech 95 · Albuquerque, NMThe pilot's improper inflight decision to make a landing on an unlit runway and his failure to maintain directional control of the airplane. Factors were the inoperative runway lights, bright lights from surrounding areas, and the pilot's attention being…NTSB FTW96LA032Accident · No injuriesLimited investigationFinal reportCessna 175 · Deer, ARThe pilot's selection of a downwind runway for landing. Factors were the tailwind and the pilot's misinterpretation of the wind conditions.NTSB FTW96LA023Accident · No injuriesLimited investigationFinal reportCessna 172D · Pryor, OKThe high wind and the pilot's poor judgment in attempting the flight.NTSB CHI96FA017Accident · 1 fatalField investigationFinal reportCessna 421C · Battle Creek, MIthe pilot's decision to fly in adverse weather (icing) conditions; the accumulation of airframe ice; and the pilot's failure to maintain adequate airspeed for the situation, which resulted in a loss of aircraft control. The icing condition was a related…NTSB BFO96LA014Accident · No injuriesLimited investigationFinal reportMooney M20E · Shady Side, MDthe partial loss of engine power due to a leaking fuel line.NTSB BFO96LA013Accident · Serious injuriesLimited investigationFinal reportZenair CH 2000 · Saluda, VAthe pilot's failure to maintain control of the airplane during an attempted go around.NTSB ATL96LA008Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Tuscaloosa, ALFatigue failure of the number one piston assembly, which resulted in a loss of engine power.NTSB ANC96LA008Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain directional control of the airplane, while attempting to negotiate a bend (dog-leg) in the runway. Factors relating to the accident were: variable/gusty wind…NTSB NYC96LA015Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chester, CTThe pilot's failure to attain adequate airspeed, and his delay in aborting the takeoff, which resulted in a runway overrun and collision with trees. Factors relating to the accident were: the wet runway and hydroplaning conditions.NTSB MIA96TA014Accident · No injuriesFinal reportCessna 182R · Redstone Arsena, ALthe pilot's poor inflight planning decision for not flying the scheduled time and electing to perform 3 additional takeoffs not planned during fuel consumption calculations. Contributing to the accident was the use of an inaccurate dipstick.NTSB MIA96LA012Accident · 1 fatalLimited investigationFinal reportGlasflugel Mosquito · Dunlap, TNthe failure of the pilot to maintain airspeed resulting in a spin at an altitude insufficient for recovery.NTSB LAX96LA019Accident · Serious injuriesLimited investigationFinal reportEaa Chapter 163 Breezy RLU-1A · Henderson, NVthe pilot's failure to maintain a proper cruise altitude and his inadequate in-flight planning. Contributing factors were encountering rising terrain and a downdraft.NTSB LAX96LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Battle Mountain, NVthe pilot's failure to see and avoid utility transmission wires suspended across the final approach flight path.NTSB LAX96LA003Accident · 1 fatalLimited investigationFinal reportFallbeck Dyke Delta JD2 · Safford, AZImproper planning/decision by the owner/builder (pilot), which resulted in his failure or inability to recover from a stall/mush condition.NTSB CHI96LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocie, MOfailure of the number three exhaust valve.NTSB ATL96LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Charlotte, NCThe pilot's inadequate preflight/planning which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB MIA96LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Ormond Beach, FLThe student pilot's improper recovery from a bounced landing and his failure to execute a go-around. Contributing to the accident were: the student pilot's high, fast approach and his misjudgment of the flare during landing.NTSB LAX96TA016Accident · No injuriesFinal reportHughes OH-6A · Imperial, CAThe pilot's improper planning/decision and failure to ensure there was an adequate supply of fuel, which led to fuel exhaustion and a forced (autorotative) landing.NTSB FTW96LA022Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Tahoka, TXthe pilot's failure to maintain clearance from wires. Factors were the loss of aileron control and the lack of suitable terrain for a forced landing.NTSB FTW96LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Kingston, OKthe pilot's inadequate compensation for the wind gusts. Factors were the gusts and the dark night conditions.NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.NTSB ATL96LA007Accident · No injuriesLimited investigationFinal reportBeech 23 · Newnan, GAa loose fuel line fitting, which resulted in a fuel leak and premature emptying of the left fuel tank; failure of the pilot to follow the checklist (select the fullest fuel tank for landing); fuel starvation; and subsequent Loss of engine power, while on…NTSB ANC96LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's selection of unsuitable terrain for landing. Soft sandy terrain was a related factor.NTSB SEA96LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Laurel, MTthe student pilot's improper planning/decision, which resulted in inadequate altitude/clearance from hangar buildings and a subsequent emergency landing, while attempting to evade a flock of geese. The flock of geese was a related factor.NTSB NYC96LA014Accident · No injuriesLimited investigationFinal reportCessna 210C · Burlington, VTa fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.NTSB NYC96FA012Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)a total loss of left engine power as a result of an in-flight separation of the #2 cylinder. The cylinder separated due to high stress fatigue cracking of the cylinder hold down studs and the #3 main bearing thru-studs. Factors in this accident were: improper…NTSB LAX96LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Mobile, AZa loss of engine power for undetermined reasons.NTSB LAX96LA015Accident · Minor injuriesLimited investigationFinal reportPetrik Questair Venture · Crescent City, CAthe pilot's failure to maintain directional control.NTSB FTW96LA019Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Waller, TXa loss of power for undetermined reasons, and the pilot misjudging distance and airspeed resulting in his failure to attain the proper touchdown point.NTSB FTW96LA018Accident · No injuriesLimited investigationFinal reportCessna 175 · Batesville, ARthe pilot's failure to maintain control of the airplane during landing.NTSB CHI96LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Anderson, INinadequate maintenance in that an engine oil line was not properly tightened after routine maintenance. A factor was the disconnected oil line.NTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.NTSB ANC96LA006Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Ninilchik, AKThe pilot's improper inflight planning/decision and inadequate compensation for the wind conditions. Turbulence and downdrafts were related factors.NTSB MIA96LA010Accident · No injuriesLimited investigationFinal reportRockwell 112A · Meridianville, ALLoss of engine power due to inadequate maintenance during the 100-hour annual. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX96WA014Accident · 1 fatalForeign investigationCessna 182 · Bahia De Los An, MexicoNTSB CHI96LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Wakeeney, KSFailure of the pilot to maintain sufficient altitude and airspeed on final approach to reach the proper touchdown point for landing. A factor relating to the accident was: the pilot's selection of the wrong runway for landing.NTSB ANC96LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Red Devil, AKLoss of engine power for an undetermined reason. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA009Accident · Minor injuriesLimited investigationFinal reportSIAI-Marchetti SF.260 · Atlantic Ocean (Atlantic Ocean)loss of engine power for undetermined reason(s), which result in a ditching at sea.NTSB LAX96LA013Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)an inadvertent encounter with unreported and unforecasted severe turbulence. A factor in the accident was the passengers' non-use of seat belts during cruise flight.NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB NYC96LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Honsdale, PAthe pilot's improper evaluation of the weather briefing, and his decision to fly into known forecasted moderate to severe icing conditions. Factors in the accident were the adverse weather conditions encountered during the flight and landing.NTSB NYC96LA009Accident · No injuriesLimited investigationFinal reportCessna 172G · Wilkes-Barre, PAthe instructor's inadequate supervision of the flight. Contributing factors were the instructor's inexperience and the student pilot's failure to maintain aircraft control.NTSB LAX96LA012Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lost Hills, CAthe pilot misjudged the aircraft's altitude.NTSB LAX96LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Brea, CAfuel exhaustion due to the pilot's improper leaning procedures and his failure to use the performance charts in the pilot operating handbook to determine fuel consumption rates for the selected cruise power setting.