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 NYC93LA058Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, PAThe pilot attempted to land in a cross wind, lost control of the airplane, landed off the runway, swerved towards a hanger after going threw a snow bank resulting in the left wing striking the hanger.NTSB MIA93LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Pascagoula, MSLoss of engine power due to undetected foreign matter contamination of the engine fuel control. The lack of a suitable landing area was a facotr in the accident.NTSB MIA93LA054Accident · Minor injuriesLimited investigationFinal reportNorth American T-28A · Plantation, FLFailure of the master rod main bearing which resulted in loss of engine power and a subsequent forced landing.NTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswindNTSB CHI93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo, MOThe pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB CHI93LA077Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIThe pilot's failure to properly align the aircraft with the landing area.NTSB CHI93IA078Incident · No injuriesIncident investigationFinal reportFokker F-28 MK 1000 · Detroit, MIImproper lubrication of the horizontal stabilizer gearbox by company maintenance personnel. A factor was the manufacturer's inadequate service procedure.NTSB LAX93LA104Accident · 4 fatalLimited investigationFinal reportFairchild Hiller FH-1100 · Volcano Natl Pk, HIA loss of tail rotor control for an undetermined reason(s). A factor which contributed to the accident was the pilot's choice of a hover altitude/position inadequate to reach a shoreline in the event of an emergency. A factor which contributed to the severity…NTSB LAX93FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Eloy, AZPartial loss of engine power due to fuel system contamination and a partially obstructed carburetor venturi, and the pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight inspection.NTSB CHI93FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wichita, KSAn improper use of the flight controls by the pilot-in-command.NTSB SEA93LA056Accident · No injuriesLimited investigationFinal reportBell 206B3 · Brigham City, UTThe location of unmarked electrical transmission wires over a designated airport taxiway. Factors relating to the accident were the pilot's lack of expectancy to encounter wires above an arpt taxiway, and his diverted attention due to the close proximity of…NTSB LAX93LA106Accident · Serious injuriesLimited investigationFinal reportEagle C-7 · San Juan Bautis, CAThe pilot's inadequate inflight planning and the unfavorable winds.NTSB LAX93LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilots inadequate compensation for the existing wind conditions and his delay in executing a go around. A factor in the accident was the pilot's lack of total experience.NTSB NYC93LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJThe failure of the pilot to maintain directional control during landing which resulted in the airplane departing the runway and nosing over. Factors related to the accident were the crosswind and the soft terrain encountered by the airplane.NTSB MIA93LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesville, FLPoor in-flight planning decision by the student pilot. Contributing to the accident was his apprehension and lack of total experience in the type of operation.NTSB LAX93LA101Accident · No injuriesLimited investigationFinal reportRobinson R22B · Palomar Mtn, CAThe student pilot's initial failure to maintain rotor RPM during the go around and the instructor's improper use of the flight controls and failure to adequately supervise the conduct of the flight.NTSB LAX93LA100Accident · 1 fatalLimited investigationFinal reportWohlers Steen Skybolt · Fountain Hills, AZThe pilot's initiation of a low level aerobatic maneuver at an altitude insufficient to ensure adequate terrain clearance.NTSB FTW93LA075Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fort Worth, TXThe pilot's failure to compensate for the crosswind. A factor was the crosswind.NTSB FTW93LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Baytown, TXThe loss of power due to a stuck exhaust valve in the number 3 cylinderNTSB FTW93LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · El Dorado, ARThe pilot's failure to maintain clearance. A factor was the dark night.NTSB DEN93LA023Accident · No injuriesLimited investigationFinal reportCessna 310L · Greeley, COPoor in flight planning and decision making by the flight instructor in allowing the student to progress to a point where a safe flight regimen could not be maintained. A factor was: the dual students failure to maintain control of the aircraft.NTSB CHI93LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Streator, ILThe pilot's failure to perform a go-around. The tailwind and the pilot's selection of the downwind runway were factor.NTSB NYC93LA054Accident · No injuriesLimited investigationFinal reportBeech A36 · Willoughby, OHThe pilot's failure to maintain the proper glide path during an instrument approach, and his improper remedial action, resulting in a collision with trees.NTSB LAX93LA105Accident · No injuriesLimited investigationFinal reportBeech 58P · Pacoima, CAThe pilot's poorly planned approach, his use of an excessive airspeed on final approach and his improper use of the brakes. A factor in the accident was his limited experience in both multi engine and in the accident aircraft.NTSB LAX93LA099Accident · No injuriesLimited investigationFinal reportCessna 172L · Ramona, CAA loss of engine power related to inadequate and improper maintenance practices concerning the carburetor.NTSB LAX93LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lost Hills, CAThe pilot's inability to maintain directional control during the landing roll out due to a binding left brake master cylinder.NTSB LAX93FA097Accident · 2 fatalField investigationFinal reportBeech A35 · Tulare, CAThe installation of an unapproved wing tip fuel tank system; an inadequate annual inspection which did not note, or correct, the unapproved fuel system addition; a wing tank fuel selector valve installation without adequate placards to show position or…NTSB SEA93LA055Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Medicine Bow, WYFailure of the #7 cylinder rocker arm. Factors contributing to the accident were unsuitable terrain and dark night conditions.NTSB LAX93FA096Accident · 1 fatalField investigationFinal reportCessna 172P · Sun City, CAThe pilot's decision to initiate VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, the adverse weather, and the mountainous terrain.NTSB FTW93FA072Accident · 3 fatalField investigationFinal reportBeech V35B · Dixie Inn, LAThe pilot's failure to maintain control for undetermined reasons.NTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.NTSB MIA93FA051Accident · Serious injuriesField investigationFinal reportCessna 140 · Niceville, FLA loss of engine power for undetermined reasons over terrain that was not suitable for the subsequent forced landing.NTSB LAX93LA092Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Watsonville, CAPilot's poor visual look-out. A factor relating to this accident was that the pilot diverted his attention.NTSB ANC93FA027Accident · 1 fatalField investigationFinal reportCessna 310 · Teller, AKThe pilot-in-command's failure to maintain an adequate terrain avoidance altitude. Factors which contributed to the accident were the dark night and featureless snow covered terrain, both which created a 'featureless terrain illusion' which probably led the…NTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.NTSB MIA93LA050Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Lantana, FLThe pilot-in-command's failure to assure that the helicopter was properly positioned on the landing platform.NTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.NTSB BFO93LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotia, NYThe student pilot's failure to maintain directional control during landing. The snow covered runway was a related factor.NTSB ATL93LA052Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Mebane, NCThe pilot's mismanagement of the fuel supply which resulted in fuel starvation to the engine.NTSB SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.NTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.NTSB MIA93WA049Accident · 2 fatalForeign investigationBeech 95-B55B · Walkers Cay, BahamasNTSB FTW93LA071Accident · Minor injuriesLimited investigationFinal reportKeller Varieze · Portland, TXA loss of engine power due to carburetor icing and the lack of suitable terrain for a forced landing.NTSB FTW93LA070Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXThe failure of the pilot to maintain directional control during the landing rollNTSB CHI93LA073Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INThe pilot's failure to maintain proper airspeed. The poorly planned approach was a factor.NTSB BFO93LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Poestenkill, NYThe total loss of engine power due to undetermined reasons.NTSB ATL93LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's failure to attain the proper touchdown point, and his improper recovery from a bounced landing. A factor was the pilot's lack of total experience in the airplane.NTSB SEA93GA052Accident · 1 fatalFinal reportHiller UH-12E · Chinook, MTInattentive FBO personnel.NTSB LAX93FA095Accident · 2 fatalField investigationFinal reportCessna 414 · Reno, NVThe failure of the pilot to use pitot static system covers during icing conditions which resulted in a blocked pitot tube and subsequent loss of airspeed indications. This led to pilot disorientation and an invertant stall. Factors to the accident were…NTSB FTW93LA069Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Godley, TXThe partial power loss due to the pilot's delayed application of carburetor heat. Factors were carburetor ice, and the sloping terrain