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 CHI93LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · California, MOThe pilot in command's failure to maintain adequate airspeed.NTSB BFO93FA113Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Madison Heights, VAEngine failure due to oil starvation as a result of inadequate maintenance and inspection of the oil cooler lines.NTSB ATL93LA126Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Bainbridge, GAThe failure of the landing gear axle.NTSB ATL93LA125Accident · No injuriesLimited investigationFinal reportPiper J3 · Athens, GAThe dual student's improper application of wheel brakes prior to lowering the tail wheel and inadequate supervision by the CFI.NTSB SEA93LA162Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Kanab, UTAn inadvertent wheel up landing. A factor to the accident was turbulence.NTSB LAX93LA280Accident · No injuriesLimited investigationFinal reportCessna 172N · Truckee, CAThe partial loss of engine power during the takeoff initial climb for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for a forced landing.NTSB LAX93LA278Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia, CAa loss of engine power for undetermined reasons.NTSB CHI93LA246Accident · No injuriesLimited investigationFinal reportCessna R172K · Middleton, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bloom, KSimproper refueling by a person or persons unknown. A factor was deteriorated fuel.NTSB BFO93LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Falmouth, MAThe pilot's inadequate compensation for wind conditions and improper recovery from a bounced landing. The gusty wind condition was a related factor.NTSB BFO93LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Normalville, PAThe presence of carburetor icing conditions, which caused a total loss of engine power. A factor related to the accident was the pilot's delayed use of carburetor heat and rough terrain.NTSB BFO93LA110Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lincoln Park, NJThe pilot's failure to maintain directional control of the airplane during landing rollout, and his delay is performing the proper remedial action of bringing back the left throttle to idle during landing rollout.NTSB LAX93LA305Accident · No injuriesLimited investigationFinal reportAyres Pitts MA-1 · Greenfield, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll and subsequent application of excessive braking that resulted in the airplane nosing over.NTSB LAX93LA279Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Coloma, CAthe passenger's injury to an ankle during the landing touchdown.NTSB LAX93LA277Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Torrance, CAAn encounter with a windshear condition. The delayed banner jettison was a factor.NTSB CHI93DTK01Accident · 1 fatalFinal reportCrowser Avid MK 3.75 · Philip, SDThe pilot's selection of unsuitable terrain for takeoff, and the pilot inadvertently stalling the airplane.NTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).NTSB BFO93LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Mayville, NYThe pilot's failure to select the proper runway for takeoff, and his failure to maintain clearance with terrain. A factor related to the accident was a prevailing tailwind.NTSB ATL93LA124Accident · No injuriesLimited investigationFinal reportCessna 177 · Atlanta, GAThe failure of the pilot to maintain directional control of the aircraft.NTSB MIA93LA150Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLThe pilot's improper in-flight planning and the lack of adequate thermal lift.NTSB MIA93LA149Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Ocala, FLPremature lift off by the pilot during takeoff.NTSB LAX93LA276Accident · 1 fatalLimited investigationFinal reportCurtis Rans S-12 · Samoa, CAThe inadvertent stall of the airplane. Factors related to this accident were: the emergency parachute system that was deployed by the pilot, the partial failure of the parachute survival equipment to deploy properly, and the insufficient information provided…NTSB LAX93LA275Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Templeton, CAFailure of the pilot to maintain correct airspeed. Factors which contributed to this accident were the improper recovery from a bounced landing and not maintaining directional control of the airplane.NTSB LAX93LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Moccasin, CAFuel exhaustion due to the pilot's failure to perform fuel consumption calculations. Factors related to this accident were: the pilot's inadequate preflight or inflight planning and preparation.NTSB LAX93FA274Accident · 5 fatalField investigationFinal reportCessna T303 · Prescott, AZThe pilot misjudging distance and altitude during a night approach. Factors which contributed to the accident were: the pilot's impairment due to fatigue exacerbated by alcohol consumption, the dark night, and the high density altitude and turbulent weather…NTSB FTW93LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, TXFuel exhaustion engine power loss due to the inadequate fuel supply for the flight. A factor was the lack of suitable terrain for the forced landingNTSB FTW93LA204Accident · No injuriesLimited investigationFinal reportCessna 177B · Shawnee, OKFuel system exhaustion induced power loss for undetermined reasons. A factor was a lack of suitable terrain.NTSB FTW93LA203Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA316B · Snyder, TXFailure of the pilot in command to properly compensate for wind conditions resulting in the loss of directional control through loss of tail rotor authority. Factors were high winds, high density altitude, and failure to jettison the external load.NTSB CHI93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mount Morris, ILThe pilot in command's failure to maintain adequate airspeed.NTSB CHI93LA242Accident · No injuriesLimited investigationFinal reportStinson V77 · St. Charles, MOThe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the wind gusts present at the time of the accident.NTSB BFO93LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob Speed Astir II · Chester, VTThe pilot's inadequate inflight planning and an in flight encounter with a downdraft while on final approach.NTSB BFO93LA106Accident · 1 fatalLimited investigationFinal reportWernega Benson KB-2 · Mount Holly, NJThe pilot's improper use of the gyroplane's flight controls.NTSB BFO93LA105Accident · 1 fatalLimited investigationFinal reportAdolfson Starduster SA300 · Windsor, NYLoss of engine power during initial climbout due to undetermined reasons. A factor related to the accident was the pilot's failure to maintain adequate airspeed following the loss of engine power, leading to an aerodynamic stall.NTSB BFO93FA107Accident · Serious injuriesField investigationFinal reportUS/Lta 138S Airship · New York, NYInadequate design of, and design standards for, the airship which resulted in an envelope failure following separation of a portion of the night sign equipment.NTSB SEA93LA148Accident · No injuriesLimited investigationFinal reportCessna 414A · Seattle, WAThe disengagement of the gear down-lock mechanism due to corrosion and the pilot's intentional operation of the aircraft with known deficiencies in equipment.NTSB FTW93LA213Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Ashdown, ARThe pilot's failure to abort the landing. A factor was the wet grassNTSB FTW93LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rogers, ARThe pilot's failure to maintain control of the airplane. A factor was the tailwind.NTSB DEN93LA073Accident · No injuriesLimited investigationFinal reportCessna 177 · Akron, COThe pilot's inadequate compensation for wind conditions. Factors were: the pilot's failure to initiate a go around in a more timely manner, and gusty crosswinds.NTSB BFO93LA104Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Culpeper, VAThe pilot's failure to maintain directional control during landing rollout. A factor related to the accident include a ditch.NTSB ANC93LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Dillingham, AKThe pilot in command's attempt to takeoff with insufficient airspeed. A factor in the accident was the pilot in command's selection of unsuitable terrain on which to land and takeoff.NTSB ANC93LA110Accident · No injuriesLimited investigationFinal reportCessna 180J · Delta Junction, AKThe pilot in command's delay in aborting the takeoff. The trees were a factor in the accident.NTSB SEA93LA147Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Heber City, UTThe pilot's improper in-flight planning/decision and failure to maintain runway alignment during the go-around. The weather conditions were related factors.NTSB SEA93LA146Accident · 1 fatalLimited investigationFinal reportDoellefeld RV6A · Independence, ORAn in flight loss of contol for unknown reasons.NTSB MIA93LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tampa, FLthe improper welding/repair by maintenence personnel of the exhaust system, which eventually failed allowing hot exhaust gasses and flame to burn a fuel line and start a fire.NTSB LAX93LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Malibu, CAthe inadequate annual inspection by other maintenance personnel and the worn fuel selector valve shaft. Contributing to this accident was the loss of power due to fuel starvation.NTSB LAX93FA272Accident · 1 fatalField investigationFinal reportBell 47G2-M · S. Sn Francisco, CAThe pilot's inadequate preflight planning/preparation which resulted in flight into high winds, turbulence and windshear.NTSB FTW93LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Lampasas, TXFuel exhaustion engine power loss due to an inadequate preflight preparation. A factor was the lack of suitable terrain for the forced landingNTSB CHI93LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Felton, MNThe pilot-in-command's failure to maintain airspeed. Factors contributing to the accident were a cracked carburetor float, fuel starvation, and the failure to perform an annual inspection.NTSB CHI93LA241Accident · No injuriesLimited investigationFinal reportCessna U206A · Kimberling City, MOA rock lodged in the left brake assembly.NTSB ATL93LA123Accident · 1 fatalLimited investigationFinal reportGulfstream G-164B · Selmer, TNThe pilot's failure to maintain adequate clearance from the power lines.