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 SEA96LA202Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mapleton, UTthe pilot's improper flare, which resulted in a hard landing.NTSB NYC96LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Rome, NYThe pilot's improper decision to take off on a runway of insufficient length, and his failure to obtain adequate airspeed.NTSB NYC96LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Hamilton Twp, NJA complete loss of engine power due to inadequate maintenance that contributed to a loose fuel line fitting, a fuel leak and subsequent fuel starvation. The uneven terrain was a factor.NTSB NYC96FA174Accident · No injuriesField investigationFinal reportLockheed L-1011-100 · Jamaica, NYfailure of the flight crew to complete the published checklist and to adequately cross-check the actions of each other, which resulted in their failure to detect that the leading edge slats had not extended and led to the aircraft's tail contacting the runway…NTSB MIA96LA217Accident · No injuriesLimited investigationFinal reportPiper J3 · Aiken, SCthe pilot's improper flare, which resulted in a hard landing; and his loss of directional control, which was followed by impact with trees.NTSB FTW96LA360Accident · Minor injuriesLimited investigationFinal reportCresap Early Bird Jenny · Kersey, COFailure of the throttle linkage. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA359Accident · Serious injuriesLimited investigationFinal reportFernandez Baby ACE D · New Raymer, COThe pilot's loss of control for reasons undetermined.NTSB FTW96LA357Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lubbock, TXinadequate maintenance by maintenance personnel, which resulted in a total loss of engine power when the magneto disengaged from the engine. A related factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA337Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Wausau, WIthe pilot's selection of an unsuitable landing area, and his misjudgment of distance and speed, while attempting to minimize the effect of crossing an uneven area on the runway. The uneven runway condition was a related factor.NTSB SEA96LA204Accident · No injuriesLimited investigationFinal reportPrice Acro Sport II · Coeur D'Alene, IDthe pilot's improper inflight planning/decision, and his failure to properly monitor (manage) the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing. Soft terrain in the forced landing area was a related factor.NTSB SEA96FA201Accident · 1 fatalField investigationFinal reportBeech D50 · Seattle, WAfailure of the pilot to follow proper emergency procedures (properly configure the airplane and feather the appropriate propeller) after loosing power in one engine, which resulted in his inability to maintain altitude until reaching an airport. Factors…NTSB NYC96LA172Accident · Minor injuriesLimited investigationFinal reportPzl-Bielsko SZD-59 · Franconia, NHThe pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.NTSB MIA96LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Williamson, GAThe failure of the pilot to maintain directional control during takeoff.NTSB LAX96LA319Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA20-A1 · S. Lake Tahoe, CAThe pilot's inadequate use of the brakes, which resulted in loss of directional control while taxiing in a non-movement area.NTSB LAX96LA314Accident · No injuriesLimited investigationFinal reportCessna 172M · Truckee, CAthe student pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control. The encounter with a ditch was a related factor.NTSB LAX96FA317Accident · No injuriesField investigationFinal reportCessna 441 · Phoenix, AZblockage of the fuel vent system due to mud from wasp nest(s). Inadequate maintenance was a related factor.NTSB IAD96LA140Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Frederick, MDthe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain.NTSB FTW96LA402Accident · No injuriesLimited investigationFinal reportCessna TR182 · Telluride, COfailure of the generator control unit (GCU), which resulted in a total electrical failure and failure of the main landing gear to lock in place.NTSB FTW96LA362Accident · No injuriesLimited investigationFinal reportCessna 172H · Durango, COthe pilot's improper flaring of the airplane at too high an altitude, resulting in a hard landing.NTSB FTW96LA361Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Rio Rancho, NMthe pilot's failure to maintain clearance from the power lines. The variable wind condition was a related factor.NTSB FTW96LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Tulsa, OKlow fluid level in the hydraulic reservoir, due to inadequate maintenance/inspection, which resulted in an inoperative brake system. Factors relating to the accident were: the down sloping runway, and trees at the departure end of the runway.NTSB CHI96LA338Accident · No injuriesLimited investigationFinal reportCessna 175 · Dexter, IAthe pilot's inadequate short field landing procedure/technique. The tailwind and grass runway were related factors.NTSB ATL96LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Waycross, GAThe student pilot's improper flare and recovery from a bounced landing.NTSB ATL96FA123Accident · 2 fatalField investigationFinal reportBurkhart Grob G-115D · Indiantown, FLfailure of maintenance personnel to rebalance the flight controls after the airplane had been repainted, which resulted in rudder flutter and in-flight breakup of the airplane.NTSB ANC96LA130Accident · No injuriesLimited investigationFinal reportMaule M-7 · Palmer, AKThe pilot's selection of an unsuitable landing area.NTSB ANC96FA131Accident · 2 fatalField investigationFinal reportMaule M-7 · Barrow, AKthe pilot's inadequate weather evaluation and resultant flight into adverse weather conditions. Factors associated with the accident were: high winds and terrain induced turbulence.NTSB SEA96LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Greybull, WYthe pilot's misjudged recovery (remedial action) from a simulated autorotation demonstration.NTSB NYC96LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Coatsville, PAloss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and the lack of suitable landing areas.NTSB LAX96LA313Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Redlands, CAthe pilot's improper weather evaluation. The uphill runway condition and weather associated with thunderstorm(s) were related factors.NTSB IAD96LA139Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Annapolis, MDfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall and subsequent collision with water.NTSB FTW96LA356Accident · No injuriesLimited investigationFinal reportBell 47 Soloy · Intracoastal, LAthe loss of aircraft control by unknown person(s).NTSB FTW96LA355Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Clinton, LAthe instructor pilot's failure to follow recommended procedures to properly brace himself in preparation for landing.NTSB CHI96LA313Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNthe pilot's failure to maintain clearance from known transmission lines. Factors relating to this accident were the transmission lines and the sunglare which hindered the pilot's ability to see the transmission lines.NTSB SEA96LA200Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Waitsburg, WAthe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane after encountering a whirlwind during the landing.NTSB SEA96LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Sisters, ORinadequate preflight planning/preparation by the flight instructor (CFI), and his failure to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall. Excessive gross weight, high density altitude, and improper use of flaps were…NTSB SEA96LA198Accident · Serious injuriesLimited investigationFinal reportBell 206B · Glenns Ferry, IDfuel contamination, due to improper servicing of the helicopter, which resulted in an intermittent loss of engine power. A factor relating to the accident was: the pilot's inadequate control of the helicopter, during autorotation with intermittent engine…NTSB SEA96LA196Accident · Serious injuriesLimited investigationFinal reportWestcott Glasair I-FT · Puyallup, WAfailure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.NTSB MIA96LA215Accident · No injuriesLimited investigationFinal reportCessna 210M · Opa Locka, FLthe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation, a forced landing, and subsequent in flight collision with terrain. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI96LA315Accident · No injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe instructor pilot delayed the remedial action and failed to maintain adequate supervision. The slow airspeed maintained by the student pilot was a factor.NTSB CHI96LA312Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Urbana, ILthe pilot's failure to maintain airspeed. A factor was the diverted attention of the pilot.NTSB CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.NTSB LAX96FA310Accident · 1 fatalField investigationFinal reportBell/Tsirah 209AH-1FT · Palmdale, CAthe first pilot misjudged the distance from the rock outcropping. The pilot's ostentatious display was a factor in this accident.NTSB IAD96FA138Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Whitefield, NHthe pilot's failure to adequately preflight the aircraft which led to the loss of engine power due to fuel exhaustion, and the pilot's attempt to return to the airport by executing a steep left turn which led to a stall and subsequent loss of control of the…NTSB FTW96LA353Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Hale Center, TXthe pilot's inadequate preflight planning/preparation and failure to obtain and/or maintain adequate airspeed after takeoff, which resulted in an inadvertent stall/mush. The overweight condition of the airplane and high density altitude were related factors.NTSB FTW96FA352Accident · 2 fatalField investigationFinal reportGrumman American AA-1B · Boulder, COThe pilot's poor judgment in attempting low altitude flight in mountainous terrain without adequate mountain flying training which led to low altitude maneuvering exceeding the climb capability of the airplane. Factors in the accident were: the pilot's…NTSB CHI96LA310Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Galesburg, ILfailure of the pilot to maintain clearance from trees that protruded into the field that he was spraying.NTSB CHI96LA308Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Grosse Ile, MIimproper attachment of the flight control cables to the ailerons by the mechanic who performed the last annual inspection. A factor relating to this accident was the pilot's failure to perform an adequate check of the flight controls before takeoff.NTSB CHI96FA316Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hartford, MIinaccurate fuel consumption calculations by the pilot before takeoff, and his improper decision not to land before his airplane ran out of fuel.NTSB ATL96LA122Accident · Serious injuriesLimited investigationFinal reportAmerican AA5 · Crestview, FLthe pilot's improper operation of the powerplant controls.NTSB SEA96TA192Accident · No injuriesFinal reportBell UH-1H · Pendleton, ORundetermined malfunction/failure of a flight control or hydraulic system. Rough terrain in the emergency landing area was a related factor.