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 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.Jan 27, 1993 · N5262H · Substantial damageNTSB 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.Jan 27, 1993 · N6612C · Substantial damageNTSB 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.Jan 27, 1993 · N203CB · Substantial damageNTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswindJan 27, 1993 · N5414Q · Substantial damageNTSB CHI93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo, MOThe pilot's failure to refuel the airplane prior to fuel exhaustion.Jan 27, 1993 · N5322P · Substantial damageNTSB CHI93LA077Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIThe pilot's failure to properly align the aircraft with the landing area.Jan 26, 1993 · N37224 · Substantial damageNTSB 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.Jan 26, 1993 · N452US · No damageNTSB 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…Jan 25, 1993 · N427FH · DestroyedNTSB 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.Jan 25, 1993 · N2144P · DestroyedNTSB CHI93FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wichita, KSAn improper use of the flight controls by the pilot-in-command.Jan 25, 1993 · N444TD · DestroyedNTSB 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…Jan 24, 1993 · N39088 · Substantial damageNTSB LAX93LA106Accident · Serious injuriesLimited investigationFinal reportEagle C-7 · San Juan Bautis, CAThe pilot's inadequate inflight planning and the unfavorable winds.Jan 24, 1993 · N7000J · No damageNTSB 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.Jan 24, 1993 · N737EA · Substantial damageNTSB 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.Jan 23, 1993 · N52491 · Substantial damageNTSB 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.Jan 23, 1993 · N714RG · Substantial damageNTSB 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.Jan 23, 1993 · N2335Q · Substantial damageNTSB 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.Jan 23, 1993 · N8LW · DestroyedNTSB FTW93LA075Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fort Worth, TXThe pilot's failure to compensate for the crosswind. A factor was the crosswind.Jan 23, 1993 · N101NZ · Substantial damageNTSB FTW93LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Baytown, TXThe loss of power due to a stuck exhaust valve in the number 3 cylinderJan 23, 1993 · N73405 · Substantial damageNTSB FTW93LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · El Dorado, ARThe pilot's failure to maintain clearance. A factor was the dark night.Jan 23, 1993 · N7676C · Substantial damageNTSB 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.Jan 23, 1993 · N3303X · Substantial damageNTSB 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.Jan 23, 1993 · N2248X · Substantial damageNTSB 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.Jan 22, 1993 · N2890A · Substantial damageNTSB 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.Jan 22, 1993 · N4458S · Substantial damageNTSB LAX93LA099Accident · No injuriesLimited investigationFinal reportCessna 172L · Ramona, CAA loss of engine power related to inadequate and improper maintenance practices concerning the carburetor.Jan 22, 1993 · N7965G · Substantial damageNTSB 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.Jan 22, 1993 · N6654 · Substantial damageNTSB 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…Jan 21, 1993 · N595B · DestroyedNTSB 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.Jan 20, 1993 · N56924 · Substantial damageNTSB 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.Jan 20, 1993 · N53908 · DestroyedNTSB FTW93FA072Accident · 3 fatalField investigationFinal reportBeech V35B · Dixie Inn, LAThe pilot's failure to maintain control for undetermined reasons.Jan 19, 1993 · N74DC · DestroyedNTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.Jan 19, 1993 · N60SX · Substantial damageNTSB 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.Jan 18, 1993 · N89968 · Substantial damageNTSB 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.Jan 18, 1993 · N2304P · Substantial damageNTSB 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…Jan 18, 1993 · N1776G · DestroyedNTSB 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.Jan 17, 1993 · N24908 · Substantial damageNTSB 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.Jan 17, 1993 · N117TV · Substantial damageNTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.Jan 17, 1993 · N48863 · Substantial damageNTSB 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.Jan 17, 1993 · N6379M · Substantial damageNTSB ATL93LA052Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Mebane, NCThe pilot's mismanagement of the fuel supply which resulted in fuel starvation to the engine.Jan 17, 1993 · N3523R · DestroyedNTSB 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.Jan 16, 1993 · N8004K · DestroyedNTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.Jan 16, 1993 · N161RS · Substantial damageNTSB MIA93WA049Accident · 2 fatalForeign investigationBeech 95-B55B · Walkers Cay, BahamasJan 16, 1993 · N99ZG · DestroyedNTSB 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.Jan 16, 1993 · N90LH · DestroyedNTSB FTW93LA070Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXThe failure of the pilot to maintain directional control during the landing rollJan 16, 1993 · N56221 · Substantial damageNTSB CHI93LA073Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INThe pilot's failure to maintain proper airspeed. The poorly planned approach was a factor.Jan 16, 1993 · N45563 · Substantial damageNTSB BFO93LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Poestenkill, NYThe total loss of engine power due to undetermined reasons.Jan 16, 1993 · N7804W · Substantial damageNTSB 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.Jan 16, 1993 · N8226L · Substantial damageNTSB SEA93GA052Accident · 1 fatalFinal reportHiller UH-12E · Chinook, MTInattentive FBO personnel.Jan 15, 1993 · N28908 · Minor damageNTSB 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…Jan 15, 1993 · N4733G · DestroyedNTSB 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 terrainJan 15, 1993 · N22R · Substantial damage