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 FTW97LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Floydada, TXThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the locked left main wheel brake.NTSB LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.NTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.NTSB FTW97FA051Accident · 3 fatalField investigationFinal reportEurocopter AS350B2 · High Island A20This case was modified 6/26/2006. The failure of the tail rotor pitch change link due to a fatigue fracture, which resulted in a loss of tail rotor control and separation of the aft tailboom.NTSB LAX97LA054Accident · No injuriesLimited investigationFinal reportCessna 172G · Chino, CAthe pilot's attempt to taxi with a crosswind component well in excess of the aircraft's maximum factory demonstrated capability. The wind conditions were factors.NTSB FTW97LA050Accident · No injuriesLimited investigationFinal reportCessna 172H · Hammond, LAthe pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.NTSB FTW97FA049Accident · 1 fatalField investigationFinal reportBeech A36TC · Tucumcari, NMthe total loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed.NTSB CHI97LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Bowbells, NDthe pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.NTSB ATL97LA027Accident · No injuriesLimited investigationFinal reportBeech 35 · Lafayette, GAfailure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB ATL97LA020Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · St. Petersburg, FLFuel exhaustion for undetermined reasons.NTSB NYC97FA021Accident · 2 fatalField investigationFinal reportCessna 414 · Duo, WVThe pilot's inadequate inflight decision which resulted in VFR flight into instrument meteorological conditions and his failure to maintain adequate terrain clearance which resulted in an inflight collision with terrain. The low ceiling was a factor.NTSB ATL97LA019Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Soperton, GAfailure of the pilot either to attain the proper touch down point for landing or to abort the landing while there was sufficient runway remaining. The terrain (ditch) at the end of the runway was a related factor.NTSB ANC97FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Bethel, AKfailure of the pilot to maintain control of the airplane, while maneuvering to reverse direction after takeoff, after encountering an undetermined anomaly. The undetermined anomaly was a related factor.NTSB LAX97LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAimproper flare by the pilot during the landing, and his improper recovery from a bounced landing, which resulted in a hard landing, dragged wing tip, and a collapsed main gear.NTSB ANC97LA007Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKfailure of the pilot to maintain adequate distance from an airport sign, while taxiing on an unfamiliar airport.NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.NTSB MIA97LA029Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Charlotte, NCfailure of the pilot maintain directional control of the aircraft, while landing. The proximity of trees was a related factor.NTSB CHI97IA034Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-211 · Romulus, MIrestricted movement of the autopilot mode engagement/disengagement lever bearing in the rudder artificial feel and trim unit. A factor relating to this incident was: company management not implementing the respective service bulletin.NTSB NYC97LA020Accident · No injuriesLimited investigationFinal reportZukowski EAA Biplane · Williamsport, PAthe pilot's inadequate preflight preparation, which resulted in opening of the unsecured canopy during the takeoff roll, and subsequent loss of directional control and a nose over. A factor was: the pilot's failure to use a checklist.NTSB MIA97LA028Accident · 1 fatalLimited investigationFinal reportNorth American T28B · Somerville, TNthe pilot misjudged his altitude/clearance above trees on terrain that was higher than the surrounding terrain, while performing an aerobatic maneuver.NTSB LAX97LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAthe pilot's improper landing flare and recovery from a subsequent bounced landing.NTSB FTW97TA046Accident · No injuriesFinal reportAerospatiale AS-355-F1 · Taos, NMThe pilot's failure to maintain directional control. A factor was terrain induced turbulence.NTSB FTW97IA045Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Dfw Airport, TXThe failure of the low pressure turbine shaft. A factor was the coke build up on the low pressure turbine shaft.NTSB DCA97WA011Accident · 125 fatalForeign investigationBoeing 767 · Comorso Islands, EthiopiaNTSB LAX97FA050Accident · 3 fatalField investigationFinal reportMooney M20J · Scottsdale, AZthe pilot misjudged the landing flare and failed to maintain directional control after a hard bounced landing.NTSB LAX97FA049Accident · 1 fatalField investigationFinal reportBeech 95-C55 · San Diego, CAthe pilot's lack of situational awareness (becoming lost/disoriented during the approach), his failure to fly the approach as charted, and his failure to maintain aircraft control, while attempting an abrupt turn toward the airport, which led to an…NTSB CHI97LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MOthe pilot's failure to maintain an adequate visual lookout.NTSB CHI97LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hart, MIthe pilot's failure to maintain directional control on rollout.NTSB NYC97FA019Accident · No injuriesField investigationFinal reportCessna 172N · Andover, MAfailure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.NTSB LAX97LA061Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600N · Flagstaff, AZThe pilot's inattention to the altitude and inadvertent late entry into an autorotation maneuver below the established minimum test altitude with a helicopter operating at maximum gross weight in a high density altitude environment that led to a subsequent…NTSB LAX97FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Lost Hills, CAThe pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…NTSB SEA97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper in-flight planning/decision, which allowed his aircraft to encounter wake turbulence from a Lear Jet, and/or the student allowed the aircraft to stall. The crosswind component from the quartering headwind was a possible factor.NTSB MIA97LA027Accident · No injuriesLimited investigationFinal reportCessna A188B · Ocilla, GAthe pilot's inadequate fuel consumption calculations and failure to ensure the aircraft contained an adequate amount of fuel to complete the flight, which resulted in loss of engine power because of fuel exhaustion. Uneven terrain in the emergency landing…NTSB MIA97LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Gulf Shores, ALInadequate maintenance/inspection of the aircraft engine, which allowed continued use of a deteriorated ignition harness and subsequent loss of engine power.NTSB LAX97LA051Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Bishop, CAa clear air turbulence encounter.NTSB LAX97LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZthe pilot's misjudged landing flare and improper bounced landing recovery technique, which led to an inadvertent porpoise.NTSB LAX97FA046Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Goleta, CAfailure of the pilot to maintain control of the aircraft during an instrument approach, due to spatial disorientation, and/or his failure to maintain proper altitude. Factors relating to the accident were: the pilot's delay (or failure) to initiate a missed…NTSB FTW97RA055Accident · No injuriesForeign investigationBell 407 · Moran, SpainNTSB FTW97FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Fort Worth, TXthe pilots' continued descent of the aircraft below decision height. Factors contributing to the accident were the fog, the dark night illumination, one of the pilot's impairment due to use of marihuana, and both pilots' fatigue.NTSB CHI97IA033Incident · No injuriesIncident investigationFinal reportBoeing 767-300ER-33A · Chicago, ILthe approach controller's failure to issue the frequency change to the flightcrew, and the pilot landing without clearance. A factor relating to this incident is the pilot's decision to land without clearance.NTSB CHI97IA031Incident · No injuriesIncident investigationFinal reportATR 42 · Covington, KYimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB SEA97LA030Accident · No injuriesLimited investigationFinal reportCessna 421B · Olympia, WAinoperative deicing equipment, due to multiple wing boot holes and malfunctioning control/shuttle valves; subsequent build-up of airframe (wing) ice; and failure of the pilot to maintain adequate airspeed during the flare for landing. Factors relating to the…NTSB SEA97LA029Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Ballston, ORa loss of control for undetermined reasons.NTSB DCA97MA009Accident · 14 fatalClass 1 · MajorFinal reportBeech 1900C · Quincy, ILthe failure of the pilots in the King Air A90 to effectively monitor the common traffic advisory frequency or to properly scan for traffic, resulting in their commencing a takeoff roll when the Beech 1900C (United Express flight 5925) was landing on an…NTSB CHI97FA030Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Grand Rapids, MIa passenger sustained a fractured ankle during an emergency evacuation for undetermined reasons.NTSB MIA97LA024Accident · No injuriesLimited investigationFinal reportCessna 182C · Anderson, SCthe pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.NTSB LAX97FA044Accident · 1 fatalField investigationFinal reportCessna 152 · Gilroy, CAflight by the pilot into into adverse weather conditions, and his failure to maintain altitude or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB FTW97FA042Accident · 5 fatalField investigationFinal reportPiper Aerostar 601P · Eagle, COThe pilot initiating flight into known adverse weather conditions without proper certification. Factors were the meteorological conditions that existed --- low ceiling, low visibility, and falling snow --- and his use of contraindicated drugs.NTSB CHI97LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Lansing, ILthe pilot's improper planning/decision, and his failure to go around, while there was still sufficient runway remaining. The unfavorable wind condition was a related factor.NTSB CHI97IA029Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hopkensville, KYthe materials used in the new windshield, to meet new EPA requirements, were inadequate for the design.