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.

NTSB BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.Jun 26, 1991 · N2641J · Substantial damageNTSB 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.Jun 25, 1991 · N40450 · Substantial damageNTSB MIA91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PROil exhaustion for undetermined reasons.Jun 25, 1991 · N5513J · Substantial damageNTSB 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.Jun 25, 1991 · N759KM · Substantial damageNTSB 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.Jun 25, 1991 · N3674V · Substantial damageNTSB 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.Jun 25, 1991 · N93097 · Substantial damageNTSB BFO91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Beckley, WVThe pilot's failure to attain adequate flying speed.Jun 25, 1991 · N20430 · DestroyedNTSB 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…Jun 25, 1991 · N91SM · DestroyedNTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.Jun 24, 1991 · N5530K · Substantial damageNTSB 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.Jun 24, 1991 · N8382B · Substantial damageNTSB 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.Jun 24, 1991 · N8278G · Substantial damageNTSB 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.Jun 24, 1991 · N2126K · Substantial damageNTSB CHI91LA200Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olathe, KSDirectional control was not maintained by the pilot. A factor related to the accident is crosswind.Jun 24, 1991 · N87113 · Substantial damageNTSB 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.Jun 23, 1991 · N4571R · Substantial damageNTSB 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.Jun 23, 1991 · N13JV · Substantial damageNTSB LAX91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rio Vista, CAFuel exhaustion due to the pilots improper fuel consumption calculations and inadequate preflight planning.Jun 23, 1991 · N1029H · Substantial damageNTSB 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…Jun 23, 1991 · N4081K · DestroyedNTSB 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.Jun 23, 1991 · N1241U · Substantial damageNTSB 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.Jun 23, 1991 · N351R · DestroyedNTSB 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.Jun 23, 1991 · N4227N · DestroyedNTSB BFO91LA056Accident · No injuriesLimited investigationFinal reportCessna 206 · Frederick, MDThe pilot of the other aircraft failed to maintain adequate clearance with a parked aircraft.Jun 23, 1991 · N734LN · 2 aircraft · Substantial damageNTSB 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.Jun 23, 1991 · N9217T · Substantial damageNTSB 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.Jun 23, 1991 · N5739C · Substantial damageNTSB 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.Jun 23, 1991 · N8635D · Substantial damageNTSB 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.Jun 22, 1991 · N4700U · Substantial damageNTSB 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.Jun 22, 1991 · N4821T · Substantial damageNTSB 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.Jun 22, 1991 · N4607P · Substantial damageNTSB LAX91LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Pacoima, CAThe pilot's improper preflight planning/preparation and his failure to attain the proper altitude.Jun 22, 1991 · N8745N · DestroyedNTSB 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.Jun 22, 1991 · N7P · Substantial damageNTSB 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.Jun 22, 1991 · N45GD · DestroyedNTSB 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.Jun 22, 1991 · N6MN · Substantial damageNTSB 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.Jun 22, 1991 · N2424J · Substantial damageNTSB 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.Jun 22, 1991 · N8089K · DestroyedNTSB BFO91LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Baltimore, MDThe pilot's improper flare and improper recovery from a bounced landing.Jun 22, 1991 · N3026Q · Substantial damageNTSB 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.Jun 21, 1991 · N7350E · Substantial damageNTSB 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.Jun 21, 1991 · N9102R · Substantial damageNTSB 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.Jun 21, 1991 · N4733B · Substantial damageNTSB 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…Jun 21, 1991 · N3573X · Substantial damageNTSB 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.Jun 21, 1991 · N4596W · Substantial damageNTSB 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.Jun 21, 1991 · N8024W · Substantial damageNTSB CHI91LA198Accident · No injuriesLimited investigationFinal reportCessna 180 · Grayling, MIThe pilot in command's failure to maintain directional control during landing roll.Jun 21, 1991 · N2755C · Substantial damageNTSB 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.Jun 21, 1991 · N6503A · Substantial damageNTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).Jun 21, 1991 · N36743 · DestroyedNTSB 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.Jun 21, 1991 · N40304 · Substantial damageNTSB 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.Jun 20, 1991 · N9830V · Substantial damageNTSB 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.Jun 20, 1991 · N4582B · Substantial damageNTSB CHI91DCJ03Accident · No injuriesFinal reportGrumman G-164-A · Edgar, NEThe pilot's inadequate aircraft preflight inspection.Jun 20, 1991 · N8842H · Substantial damageNTSB SEA91LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Vancouver, WAA hard landing by the pilot due to improper bounced landing recovery.Jun 19, 1991 · N4324R · Substantial damageNTSB SEA91LA137Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Warrenton, ORThe pilot failed to maintain proper rotor speed during a simulated autorotation.Jun 19, 1991 · N9380F · Substantial damageNTSB 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.Jun 19, 1991 · N7029C · Destroyed