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 DEN90LA116Accident · No injuriesLimited investigationFinal reportCessna 172RG · Albuquerque, NMThe cfi's improper procedures during takeoff. Factors were premature liftoff and inadvertent stall/mush.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ATL90FA119Accident · 2 fatalField investigationFinal reportCessna 177 · Canton, GAThe intentional flight into instrument meteorological conditions by the non-instrument rated pilot.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MKC90LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Ashland, KSA power plant failure for undetermined causes.NTSB 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.NTSB 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.NTSB 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.NTSB FTW90DRA05Accident · No injuriesFinal reportGrumman 164-B · Garwood, TXThe power loss due to super charger impeller failure.NTSB 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.NTSB 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.NTSB MKC90LA114Accident · No injuriesLimited investigationFinal reportCessna 182RG · Salina, KSGear down and locked not identified, and emergency procedures not performed by the pilot in command.NTSB 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.NTSB LAX90LA193Accident · Minor injuriesLimited investigationFinal reportCessna 310G · Sedona, AZThe pilot selected the wrong runway, and proper touch down point was not attained.NTSB 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.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB 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.NTSB SEA90IA085Incident · Minor injuriesIncident investigationFinal reportFairchild SA227 · Olympia, WADue to an ice build-up departing the propeller and striking the cabin window.NTSB 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.NTSB NYC90DFG03Accident · No injuriesFinal reportContinental Copters MK15A · King Ferry, NYThe pilot's failure to maintain adequate clearance from power lines during this approach to landing.NTSB 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.NTSB MIA90WA131Accident · No injuriesForeign investigationCessna 310R · Eleuthera Isl., BahamasNTSB MIA90TL#05Accident · No injuriesClass 3Final reportBell 206L-3 · Miami, FLNTSB MIA90LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Leland, MSFailure of the pilot to see-and-avoid the power lines.NTSB 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.NTSB 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.NTSB LAX90LA190Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Waialua, HIThe failure of the pilot to maintain an adequate clearance from clouds.NTSB 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…NTSB LAX90LA186Accident · Minor injuriesLimited investigationFinal reportHughes 269A · La Verne, CAGround resonance due to an inadequately maintained strut.NTSB 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.NTSB ATL90LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Greensboro, NCThe loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB SEA90LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Bremerton, WAFailure of the tail rotor control for an undetermined reason.NTSB MIA90LA126Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Perry, FLLoss of engine power for an undetermined reason.NTSB LAX90LA188Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for crosswind conditions. The crosswind was a factor in the accident.NTSB 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.NTSB 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…NTSB 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.NTSB CHI90DEK05Accident · Minor injuriesFinal reportCessna 172 · Urbana, OHWater contamination of the fuel, and the pilot's inadequate preflight, which resulted in loss of engine power.NTSB 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.NTSB SEA90LA083Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58D · Juneau, AKThe failure of the number 3 segment of the tail rotor drive shaft assembly.NTSB 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.NTSB 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.