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 BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.NTSB SEA91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Wenatchee, WAThe pilot's failure to maintain a proper altitude. Contributing to the accident was sun glare.NTSB MIA91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PROil exhaustion for undetermined reasons.NTSB LAX91LA278Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's improper flare and improper recovery from a bounced landing. Factors related to the accident were: gusty winds, the pilot's inadequate compensation for wind conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB LAX91LA276Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dana Point, CAThe seizure of the no. 1 cylinder's exhaust valve in its guide and the related fracturing of the rocker arm; and the pilot's operation of the aircraft with known deficiencies.NTSB FTW91LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Hutto, TXThe engine failure due to carburetor ice. Factors were the instructor's improper use of carburetor heat and the fouled spark plugs.NTSB BFO91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Beckley, WVThe pilot's failure to attain adequate flying speed.NTSB ATL91FA124Accident · 2 fatalField investigationFinal reportPiper PA-28 · Mt. Berry, GAThe pilot's inadequate preflight planning, his poor inflight decision to continue into deteriorating weather conditions, and his inadvertent flight into IMC. Factors in this accident were: the clouds obscuring the mountain at the time of the accident, and the…NTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.NTSB LAX91LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Payson, AZA premature liftoff, stall, and subsequent in flight collision with terrain. A factor related to the accident was the high density altitude.NTSB DEN91LA089Accident · No injuriesLimited investigationFinal reportCessna A188B · Delta, COA total power loss due to a ruptured fuel line, and the installation of an incorrect fuel line.NTSB CHI91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-201R · Wheeling, ILThe pilot in command's inadequate pre-flight inspection. Factors contributing to this accident were the landing gear lever not being engaged, the use of an inadequate procedure by the pilot-in-command, and the inadvertent gear retraction during takeoff roll.NTSB CHI91LA200Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olathe, KSDirectional control was not maintained by the pilot. A factor related to the accident is crosswind.NTSB MIA91LA177Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Bay Saint Louis, MSLoss of control in flight due to premature flare by the pilot resulting in inadvertent stall/mush, and failure of the pilot to recover from the bounced landing.NTSB MIA91LA167Accident · No injuriesLimited investigationFinal reportSwearingen SA227-TT · Tupelo, MSThe improper installation of the nose steering actuator arming valve by a mechanic which resulted in failure of the actuator and on ground loss of directional control by the pilot during landing rollout.NTSB LAX91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rio Vista, CAFuel exhaustion due to the pilots improper fuel consumption calculations and inadequate preflight planning.NTSB LAX91LA269Accident · Serious injuriesLimited investigationFinal reportGreen-Fowler Pazmany PL-1 · Wrightwood, CAFatigue fracture of one of the two propeller blades caused by the propeller modification and the non-approved propeller-engine combination. A factor in this accident was the transmission wires as an obstacle in the glide path during the attempted forced…NTSB DEN91LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Keenesburg, COThe pilot's misjudging the approach, and disregard of wind conditions. Factors were: a tailwind condition and the pilot's anxiety.NTSB CHI91DEC02Accident · 2 fatalFinal reportHoward Tierra II · Cambridge Jct, MIEntanglement of the emergency ballistic parachute with the airplane's propeller shaft after it deployed for an undetermined reason. A factor related to the accident was: the aircraft's weight and balance limit was exceeded by the pilot.NTSB CHI91DCD01Accident · 1 fatalFinal reportHeal SONERAI-I · Davenport, IAFailure of the wing spar straps, as the aircraft was being maneuvered around a pylon in an air race.NTSB BFO91LA056Accident · No injuriesLimited investigationFinal reportCessna 206 · Frederick, MDThe pilot of the other aircraft failed to maintain adequate clearance with a parked aircraft.NTSB ATL91LA118Accident · No injuriesLimited investigationFinal reportMaule MXT-180 · Mobile, ALThe pilot's failure to properly compensate for wind conditions. A factor to this accident was the gusting winds.NTSB ANC91LA080Accident · No injuriesLimited investigationFinal reportCessna 170A · Kakeen, AKThe pilot's failure to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident was the soft, rough, and uneven terrain.NTSB ANC91LA079Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Beluga, AKWas the pilot-in-command's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the rough, uneven terrain and crosswind.NTSB SEA91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180G · Challis, IDThat the pilot encountered unsuitable terrain during a forced landing after a power loss due to a fractured cylinder boss and a bent engine pushrod.NTSB NYC91LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Doylestown, PAThe flight instructor allowed the student to continue a simulated engine failure to a hard landing, resulting in a bounced landing and loss of directional control and a collision with the VASI.NTSB LAX91LA275Accident · No injuriesLimited investigationFinal reportCessna C-152 · Las Vegas, NVFuel exhaustion due to the failure of the pilot to ensure that an adequate fuel supply was on board the aircraft prior to departure.NTSB LAX91LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Pacoima, CAThe pilot's improper preflight planning/preparation and his failure to attain the proper altitude.NTSB LAX91LA271Accident · No injuriesLimited investigationFinal reportClassic YMF · Bullhead City, AZExcessive brake application by the pilot in command. A contributing factor in the accident was the wind gusts.NTSB LAX91FA270Accident · 1 fatalField investigationFinal reportBeech T-34A · Redding, CAThe pilot's failure to attain an altitude to permit the aircraft to complete the aerobatic maneuver.NTSB FTW91LA119Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Boerne, TXThe pilot's failure to release at a higher altitude prior to looking for thermal activity and the pilot's poor in-flight planning. Factors were the downdraft and the tall grass encountered during landing.NTSB FTW91LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · San Angelo, TXThe pilot's failure to refuel the airplane which resulted in engine failure due to fuel exhaustion.NTSB FTW91DPG13Accident · Serious injuriesFinal reportGrumman G-164B · Mc Crory, ARLoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB BFO91LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Baltimore, MDThe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA91LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTThe pilot's poor inflight planning and decisions in that he failed to anticipate wake turbulence from the departing helicopter.NTSB MIA91LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Doddsville, MSPoor planning decision by the pilot for failure to take into account the temperature extremes and what effect this would have on the ground roll distance. Contributing to the accident was his lack of total experience in the type of operation.NTSB MIA91LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooksville, FLFailure of the student pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was his lack of total experience.NTSB LAX91LA267Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Auburn, CAThe pilot's use of an excessive airspeed for the final approach, and the failure of the pilot to initiate a go around when it became apparent that the aircraft would land long on the runway. A factor in the accident was the limited total experience of the…NTSB FTW91LA106Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Ovilla, TXThe mechanical failure of the turbocharger. Factors were the inadequate annual inspection and the pilot's improper flare in the forced landing.NTSB CHI91LA199Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Faribault, MNCompensation for wind conditions was not attained by the pilot resulting in loss of directional control. A factor related to the accident was a gusty crosswind landing environment.NTSB CHI91LA198Accident · No injuriesLimited investigationFinal reportCessna 180 · Grayling, MIThe pilot in command's failure to maintain directional control during landing roll.NTSB CHI91LA197Accident · No injuriesLimited investigationFinal reportCessna 180 · Grand Rapids, MNThe pilot's failure to maintain a proper airspeed during landing and the improper recovery from a bounced landing. Factors related to the accident were the pilot's lack of total experience in seaplanes and the gusty wind condition.NTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).NTSB ANC91LA078Accident · No injuriesLimited investigationFinal reportMaule M4-220-C · Fairbanks, AKThe pilot's failure to maintain airspeed during the initial climb and exceeding the gross weight of the airplane. Contributing to the accident was high vegetation.NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB FTW91LA105Accident · No injuriesLimited investigationFinal reportSikorsky 58H · Corsicana, TXFailure of the magneto. Factors were the helicopter's position over water, the tailwind, and the inadequate main rotor RPM prior to touchdown.NTSB CHI91DCJ03Accident · No injuriesFinal reportGrumman G-164-A · Edgar, NEThe pilot's inadequate aircraft preflight inspection.NTSB SEA91LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Vancouver, WAA hard landing by the pilot due to improper bounced landing recovery.NTSB SEA91LA137Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Warrenton, ORThe pilot failed to maintain proper rotor speed during a simulated autorotation.NTSB LAX91LA266Accident · Serious injuriesLimited investigationFinal reportGrumman HU-16E · Pacific Ocean (Pacific Ocean)Improper touchdown in the water causing substantial damage. Loss of power on the number 2 engine and the pilot's lack of qualifications were factors in the accident.