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 ATL06CA025Accident · No injuriesData collectionFinal reportCessna 172S · Mobile, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB ANC06CA011Accident · No injuriesData collectionFinal reportCessna 208B · Newtok, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in the airplane exiting the runway, encountering snow, and the nose gear collapsing. Factors associated with the accident were the gusting wind and the icy runway.NTSB MIA06WA030Accident · No injuriesForeign investigationCessna 172 · Saint-Barthelem, GuadeloupeNTSB MIA06CA029Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Daytona Beach, FLThe flight instructor's inadequate supervision, and the student pilot's improper go-around procedures, which resulted in the airplane's left wing striking the runway.NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB SEA06CA027Accident · Minor injuriesData collectionFinal reportCessna TP206A · Snohomish, WAThe pilot's higher than normal airspeed on landing which resulted in a runway overrun. Contributing factors were the fog and the wet runway surface.NTSB MIA06CA027Accident · No injuriesData collectionFinal reportErcoupe 415C · Wiersdale, FLThe pilot's improper planning and failure to abort the takeoff in sufficient time which resulted in the airplane overrunning the runway and nosing over.NTSB LAX06LA056Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Corona, CAfailure of both pilots to see and avoid each other during traffic pattern operations at a non-towered airport.NTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…NTSB WAS06RA005Accident · 107 fatalForeign investigationMcDonnell Douglas DC-9-31 · Port Harcourt, NigeriaNTSB MIA06LA028Accident · No injuriesLimited investigationFinal reportMestas Felix R Velocity LWFG-E · Punta Gorda, FLA loss of engine power for undetermined reasons.NTSB LAX06FA054Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Kingsburg, CAThe pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.NTSB LAX06CA062Accident · No injuriesData collectionFinal reportRyan Navion · Los Angeles, CAthe pilot's failure to maintain adequate clearance from a parked vehicle.NTSB DEN06CA022Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSthe student pilot's improper decision to continue taxiing through the field. Contributing factor's include student pilot's failure to maintain control during the takeoff roll and the drainage ditch masked by snow.NTSB ATL06LA022Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-110P1 · Orangeburg, SCThe pilot's inadequate preflight inspection and her failure to refuel the airplane which resulted in total loss of engine power due to fuel exhaustion, and subsequent in-flight collision with trees.NTSB SEA06WA035Accident · 2 fatalForeign investigationCessna 152 · Clinge, NetherlandsNTSB SEA06CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Prineville, ORAircraft control not maintained by the private pilot during the initial takeoff climb, and the improper remedial action by the flight instructor. A factor was the wind gust.NTSB DFW06LA038Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot's excessive taxi speed and his excessive use of brakes.NTSB DCA06MA009Accident · 1 fatalClass 1 · MajorFinal reportBoeing 737-700 · Chicago, ILThe pilots' failure to use available reverse thrust in a timely manner to safely slow or stop the airplane after landing, which resulted in a runway overrun. This failure occurred because the pilots' first experience and lack of familiarity with the…NTSB MIA06LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Key Largo, FLA loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.NTSB CHI06CA054Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Rockford, ILFailure of the commercial pilot (dual student) to maintain a proper descent rate and a safe airspeed during the simulated forced landing. Additional causes were the failure of the flight instructor and the dual student to initiate a go-around in sufficient…NTSB ATL06LA021Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbia, SCMaintenance personnel's improper installation of the stabilator trim arm which resulted in separation of a bolt, loss of control during takeoff, and a subsequent hard landing.NTSB NYC06WA061Accident · No injuriesForeign investigationCessna 560 · Toussus LeNoble, FranceNTSB LAX06CA047Accident · No injuriesData collectionFinal reportNorth American P-51D · Minden, NVthe pilot's failure to maintain directional control on landing.NTSB CHI06CA042Accident · No injuriesData collectionFinal reportCessna 310Q · Pierre, SDThe pilot's failure to maintain control of the airplane during the landing roll due to the icy runway. Factors were the compacted snow and ice along the edges of the runway and at the taxiway intersection, and the snow banks adjacent to the runway and taxiway.NTSB LAX06WA053Accident · 1 fatalForeign investigationCessna 150G · Packsaddle, NSW, AustraliaNTSB DFW06WA039Accident · 2 fatalForeign investigationCessna A150L · Buenos Aires, ArgentinaNTSB ATL06CA033Accident · No injuriesData collectionFinal reportCessna 172H · Waycross, GAThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing.NTSB SEA06CA023Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries HK 36 TTC · Sandpoint, IDExcessive speed for the landing roll and inadequate remedial action for the initial takeoff. An object near the end of the runway and snow covered surface were factors.NTSB DEN06CA021Accident · Minor injuriesData collectionFinal reportCessna 182E · Lansing, KSthe pilot's inability to maintain aircraft control during the forced landing which resulted in a collision with terrain. A contributing factor was the pilot becoming ill during cruise flight.NTSB NYC06CA041Accident · No injuriesData collectionFinal reportRobinson R-22B · Rochester, NHThe flight instructor's failure to maintain adequate clearance while providing hovering instruction, which resulted in tail rotor ground contact. A factor in this accident was the gusty wind conditions.NTSB LAX06CA081Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe flight's encounter with downdrafts. A contributing factor was the unsuitable vegetation-covered mountainous terrain.NTSB LAX06WA051Accident · 4 fatalForeign investigationPiper PA-31-350 · Condobolin, AustraliaNTSB LAX06CA050Accident · Minor injuriesData collectionFinal reportMooney M20A · China Lake, CAfuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.NTSB SEA06CA024Accident · No injuriesData collectionFinal reportCessna 210-5 · Lopez Island, WAThe pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.NTSB NYC06FA040Accident · 1 fatalField investigationFinal reportBeech B-55 · Nantucket, MAThe pilot's failure to maintain the proper glidepath during the instrument approach, which resulted in controlled flight into water. Factors were the failure of the air traffic controllers to issue minimum safe altitude warnings, night lighting conditions,…NTSB ENG06RA004Incident · No injuriesForeign investigationBoeing 767-300B · Kagoshima, JapanNTSB DFW06FA037Accident · 3 fatalField investigationFinal reportPiper PA-30 · Raymond, MSThe pilot's failure to maintain Vmc (velocity minimum control) on initial climb resulting in a loss of control. Contributing factors were the loss of engine power to the right engine and the prevailing gusty wind conditions.NTSB CHI06WA041Accident · Minor injuriesForeign investigationBell 206L-4T · Mostóles, SpainNTSB SEA06FA022Accident · 1 fatalField investigationFinal reportCessna 425 · Belgrade, MTThe pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.NTSB CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…NTSB ATL06CA020Accident · No injuriesData collectionFinal reportCessna 152 · Sanford, NCThe student pilot's failure to maintain directional control on landing roll out, resulting in the airplane going off the left side of the runway, colliding with a ditch, and nosing over inverted.NTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.NTSB DEN06IA020Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Denver, COthe pilot's failure to maintain clearance from the taxiway light. Factors contributing to the incident were the crew's inadequate visual lookout and the taxiway light.NTSB CHI06LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-10 · Chicago, ILThe failure of the flight crew to see and avoid the crew stairs and the failure of unknown persons to properly secure the stairs after use. Factors associated with the accident were the dark light conditions and the gusty winds.NTSB DFW06CA034Accident · No injuriesData collectionFinal reportCessna 210M · Kirbyville, TXThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA06IA007Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400 · Jacksonville, FLThe dual-engine flameout due to high-altitude ice crystals that had accreted onto the JT15D-5 engines' compressor vanes and were ingested into the engine when the pilots retarded the power levers, resulting in compressor surges and rapid reduction in fuel…NTSB SEA06CA030Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Auburn, WAThe collapse of the left main landing gear after landing for undetermined reasons.NTSB NYC06LA039Accident · 1 fatalLimited investigationFinal reportRogers Lancair 360 · Vineyard Haven, MAA loss of engine power for undetermined reasons.