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 DEN90LA116Accident · No injuriesLimited investigationFinal reportCessna 172RG · Albuquerque, NMThe cfi's improper procedures during takeoff. Factors were premature liftoff and inadvertent stall/mush.May 26, 1990 · N6498R · Substantial damageNTSB CHI90LA140Accident · No injuriesLimited investigationFinal reportLet L-13 · Oxford, MIThe glider pilot's failure to maintain adequate aircraft control during the touchdown and landing roll. The poorly executed approach to landing, and rough/uneven terrain were contributing factors in this accident.May 26, 1990 · N9297Z · Substantial damageNTSB CHI90LA136Accident · No injuriesLimited investigationFinal reportCessna 182F · Clare, MIImproper maintenance by maintenance personnel resulting in a sticking carburetor float. Inadequate planning by the pilot in command during the approach is a factor in the accident.May 26, 1990 · N3632U · Substantial damageNTSB BFO90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lusby, MDThe pilot misjudged the distance needed to touchdown and stop his aircraft before running off the end of the runway. The pilot failed to use all of the available runway during the landing sequence.May 26, 1990 · N43078 · Substantial damageNTSB ATL90LA121Accident · Minor injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Pineora, GAControl interference by the passenger when the throttle was retarded and the pilot's failure to intervene because of his diverted attention.May 26, 1990 · N3261H · Substantial damageNTSB ATL90FA119Accident · 2 fatalField investigationFinal reportCessna 177 · Canton, GAThe intentional flight into instrument meteorological conditions by the non-instrument rated pilot.May 26, 1990 · N2979X · DestroyedNTSB ANC90LA080Accident · No injuriesLimited investigationFinal reportInterstate S1B1 · Beluga River, AKThe pilot selected unsuitable terrain. Contributing factors were the soft terrain and the pilot's lack of experience in off-airport operations.May 26, 1990 · N55AD · Substantial damageNTSB ANC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Wasilla, AKPilot's failure to maintain control of the airplane. Contributing to the accident was the pilot's lack of total experience.May 26, 1990 · N9288D · Substantial damageNTSB NYC90LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fraconia, PAThe pilot failed to maintain sufficient airspeed to flare for landing. Factors related to the accident were: a power loss due to oil exhaustion, the failure of the pilot to conduct an adequate pre-flight and departing with the oil dip stick loose.May 25, 1990 · N8120C · Substantial damageNTSB NYC90FA110Accident · No injuriesField investigationFinal reportBritten-Norman BN2A-2F · Blue Bell, PAThe close proximity of the road to the threshold of the runway. Factors contributing to the accident were the obstruction to the driver's vision caused by trees and buildings.May 25, 1990 · N416WA · Substantial damageNTSB MKC90LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Ashland, KSA power plant failure for undetermined causes.May 25, 1990 · N714XG · Substantial damageNTSB MIA90LA133Accident · No injuriesLimited investigationFinal reportCessna 210A · Palm Harbor, FLThe improper leaning of the fuel/air mixture resulting in the loss of engine power due to excessive internal engine temperature.May 25, 1990 · N6697X · Substantial damageNTSB LAX90LA196Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Brentwood, CAThe pilot improperly calculated the fuel consumption causing the airplane to sustain a total loss of power due to fuel exhaustion.May 25, 1990 · N5714T · Substantial damageNTSB LAX90LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Fullerton, CAFuel starvation due to the pilot's improper fuel management technique. A factor was the improperly modified fuel selector valve.May 25, 1990 · N8474D · Substantial damageNTSB FTW90DRA05Accident · No injuriesFinal reportGrumman 164-B · Garwood, TXThe power loss due to super charger impeller failure.May 25, 1990 · N9982 · DestroyedNTSB ATL90IA123Incident · No injuriesIncident investigationFinal reportBeech BE-18 · Anderson, SCThe pilot's failure to ensure adequate clearance while taxiing to the ramp. A factor in the incident was a dark, unlighted ramp area.May 25, 1990 · N52A · No damageNTSB SEA90LA087Accident · No injuriesLimited investigationFinal reportCessna 140 · Washougal, WAThe pilot's inadequate preflight inspection of the airplane, which allowed water to remain in the fuel system. Collision with a tree was a factor related to the accident.May 24, 1990 · N72592 · Substantial damageNTSB MKC90LA114Accident · No injuriesLimited investigationFinal reportCessna 182RG · Salina, KSGear down and locked not identified, and emergency procedures not performed by the pilot in command.May 24, 1990 · N7311S · Substantial damageNTSB MIA90LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, MSThe student pilot landed long and delayed applying power during the ground roll of the touch-and-go landing.May 24, 1990 · N93034 · Substantial damageNTSB LAX90LA193Accident · Minor injuriesLimited investigationFinal reportCessna 310G · Sedona, AZThe pilot selected the wrong runway, and proper touch down point was not attained.May 24, 1990 · N161A · Substantial damageNTSB LAX90LA191Accident · No injuriesLimited investigationFinal reportHughes 369FF · Madera, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered by the pilot when he turned during the autorotative descent to avoid obstacles.May 24, 1990 · N530R · Substantial damageNTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.May 24, 1990 · N85RC · 2 aircraft · Minor damageNTSB ANC90LA076Accident · No injuriesLimited investigationFinal reportCessna 185 · Uganik Bay, AKThe pilot's improper compensation for wind conditions. Factors contributing to the accident were the downdrafts and gusty winds.May 24, 1990 · N1095F · Substantial damageNTSB SEA90IA085Incident · Minor injuriesIncident investigationFinal reportFairchild SA227 · Olympia, WADue to an ice build-up departing the propeller and striking the cabin window.May 23, 1990 · N27442 · Minor damageNTSB NYC90DHA01Accident · 1 fatalFinal reportGrumman G-164A · Hunlock Creek, PAThe pilot's failure to maintain adequate clearance from obtacles, and his failure to see and avoid the electrical transmission line.May 23, 1990 · N913X · Substantial damageNTSB NYC90DFG03Accident · No injuriesFinal reportContinental Copters MK15A · King Ferry, NYThe pilot's failure to maintain adequate clearance from power lines during this approach to landing.May 23, 1990 · N9034T · Substantial damageNTSB MKC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Little Rock, ARThe failure of the powerplant due to a sheared timing gear. Contributing factors were unsuitable terrain and restricted vision due to fog.May 23, 1990 · N301KK · Substantial damageNTSB MIA90WA131Accident · No injuriesForeign investigationCessna 310R · Eleuthera Isl., BahamasMay 23, 1990 · N5039J · Substantial damageNTSB MIA90TL#05Accident · No injuriesClass 3Final reportBell 206L-3 · Miami, FLMay 23, 1990 · N303MP · Substantial damageNTSB MIA90LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Leland, MSFailure of the pilot to see-and-avoid the power lines.May 23, 1990 · N8739 · Substantial damageNTSB MIA90LA129Accident · No injuriesLimited investigationFinal reportCessna 172P · Plymouth, FLThe pilot's inadequate compensation for wind conditions. Factors related to the accident were: the crosswind and the pilot's lack of total flying expereince.May 23, 1990 · N66026 · Substantial damageNTSB MIA90IA128Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tampa, FLThe failure of the pilot to follow procedures outlined in the checklist, resulting in the airplane landing with landing gear retracted.May 23, 1990 · N62910 · Minor damageNTSB LAX90LA190Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Waialua, HIThe failure of the pilot to maintain an adequate clearance from clouds.May 23, 1990 · N15SH · Substantial damageNTSB LAX90LA187Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAImproper maintenance procedure by maintenance personnel to troubleshoot a reported deficiency and the pilot's decision to demonstrate the vibration, exceeding the design limits of the helicopter and inducing ground resonance. Contributing to the accident was…May 23, 1990 · N7441F · Substantial damageNTSB LAX90LA186Accident · Minor injuriesLimited investigationFinal reportHughes 269A · La Verne, CAGround resonance due to an inadequately maintained strut.May 23, 1990 · N8793F · Substantial damageNTSB DEN90FA115Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · La Sal, UTA failure of the engine speed governor unit due to improper storage and/or inspection of the speed governor unit prior to placing it in service. A factor in the accident was the pilot carrying passengers on the external load.May 23, 1990 · N402AH · Substantial damageNTSB ATL90LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Greensboro, NCThe loss of engine power for undetermined reasons.May 23, 1990 · N9657D · Substantial damageNTSB ATL90FA117Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Griffin, GALoss of engine power for an unknown reason. The presence of trees in the emergency landing area was a related factor.May 23, 1990 · N8064K · DestroyedNTSB ANC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe flight instructor's failure to use carburetor heat during a simulated engine failure. The rough terrain and weather conditions conducive to carburetor icing were contributing factors.May 23, 1990 · N66425 · Substantial damageNTSB SEA90LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Bremerton, WAFailure of the tail rotor control for an undetermined reason.May 22, 1990 · N8888F · Substantial damageNTSB MIA90LA126Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Perry, FLLoss of engine power for an undetermined reason.May 22, 1990 · N66BC · Substantial damageNTSB LAX90LA188Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for crosswind conditions. The crosswind was a factor in the accident.May 22, 1990 · N61602 · Substantial damageNTSB DEN90LA114Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Erie, COCfi's failure to ensure that the student pilot maintained sufficient airspeed, resulting in the inadvertent stall/mush. A factor was the downdraft experienced at low altitude after takeoff.May 22, 1990 · N714UE · Substantial damageNTSB CHI90LA134Accident · No injuriesLimited investigationFinal reportCessna 172N · Jeffersonville, INThe engine started for an undetermined reason, when the prop was moved after the pilot experienced an inoperative starter. (Most probably, there was either an isolated/intermittent problem in the ignition system or the pilot did not move the magneto switch…May 22, 1990 · N733CR · Substantial damageNTSB CHI90DEM03Accident · No injuriesFinal reportCessna T188 · Williamsburg, MIA loss of engine power for undetermined reasons. The lack of suitable terrain for landing was a factor related to the accident.May 22, 1990 · N9441J · DestroyedNTSB CHI90DEK05Accident · Minor injuriesFinal reportCessna 172 · Urbana, OHWater contamination of the fuel, and the pilot's inadequate preflight, which resulted in loss of engine power.May 22, 1990 · N6195E · Substantial damageNTSB ATL90FA118Accident · 1 fatalField investigationFinal reportCessna 182RG · Highland, NCThe pilot's attempted VFR flight in IMC. Factors in the accident are the pilot's inaccurate weather evaluation and poor in flight decision.May 22, 1990 · N55AG · DestroyedNTSB SEA90LA083Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58D · Juneau, AKThe failure of the number 3 segment of the tail rotor drive shaft assembly.May 21, 1990 · N94495 · DestroyedNTSB SEA90LA082Accident · No injuriesLimited investigationFinal reportRobert Van Scoyoc Soneria IIL · Ellensburg, WAThe loss of engine power due to carburetor icing, caused by the pilot's failure to apply carburetor heat. Factors in the accident were the carburetor icing weather conditions and the lack of suitable terrain for forced landing.May 21, 1990 · N3229Z · Substantial damageNTSB SEA90LA081Accident · 1 fatalLimited investigationFinal reportHughes 369D · Kelso, WAFailure of the pilot to keep the external load clear of obstacles (trees). Factors related to the accident were: failure of the pilot and ground crewman to follow safety procedures, and the proximity of the trees.May 21, 1990 · N8306F · No damage