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 FTW89LA092Accident · No injuriesLimited investigationFinal reportBell 47L · Tulsa, OKInadequate supervision of the student by the instructor in that he allowed the student to overpower his control inputs after an unexpected gust of wind moved the tail of the helicopter.NTSB FTW89DRG05Accident · No injuriesFinal reportGrumman-Schweizer G-164 · Edcouch, TXLoss of engine power for an undetermined reason. The corn crop was a contributing factor.NTSB CHI89LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe pilot-in-command's failure to follow proper procedures and directives and his premature decision to initiate an emergency procedure. Contributing factors were the pilot's lack of total experience and his selection of unsuitable terrain for the emergency…NTSB ATL89LA143Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Lugoff, SCInadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…NTSB ATL89FA144Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Augusta, GAFailure of the pilot to maintain adequate airspeed, while making a steep turn after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.NTSB ATL89FA142Accident · 1 fatalField investigationFinal reportEmbraer EMB-110-P1 · Mt. Pleasant, TNPilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.NTSB ANC89LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalskag, AKThe pilot's failure to maintain directional control of the airplane following a bounced landing.NTSB ANC89FA069Accident · Minor injuriesField investigationFinal reportBell 412 · Girdwood, AKA main rotor flight control bolt (part number 20-057-6-38D) came out of its rod end bearing while in flight due to the bolt being improperly torqued during maintenance.NTSB DEN89LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Durango, COInadequate inflight planning and inadequate compensation for wind conditions. Contributing to the accident were crosswind and turbulence encountered close to the ground and high density altitude conditions.NTSB DEN89LA116Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Deming, NMThe pilot's failure to maintain directional control during the takeoff ground run, resulting in a loss of control and collision with the terrain. The lack of experience in this type of aircraft is considered to be a factor.NTSB SEA89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lacey, WAFailure of the pilot to maintain proper alignment during landing.NTSB SEA89LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynden, WAThe pilot delayed in aborting the landing and failed obtain or maintain sufficient airspeed to keep the aircraft from mushing after lift-off. Factors related to the accident were: obstructions near the approach end of the runway, failure of the pilot to…NTSB MKC89LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wentzville, MOThe pilot's delay in aborting the landing, and his failure to maintain clearance from the power lines. Factors related to the accident were: the pilot's selection of the wrong runway, the adverse weather conditions, the pilot's failure to attain the proper…NTSB MKC89FA102Accident · 2 fatalField investigationFinal reportCessna 150H · Carnegie, OKContinued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather…NTSB LAX89LA179Accident · No injuriesLimited investigationFinal reportCessna 180 · Cottonwood, AZImproper flight planning/decision by the PIC when he decided to land with such a crosswind, and not maintaining compensation for the crosswind after he decided to attempt the landing.NTSB LAX89FA178Accident · 1 fatalField investigationFinal reportPiper PA-28-201T · Stockton, CAThe pilot's improper decision to perform aerobatics which resulted in the design stress limits of the airplane being exceeded due to excessive airspeed. Contributing factors to the accident were the pilot's overconfidence in his and the airplane's ability,…NTSB FTW89FA091Accident · 2 fatalField investigationFinal reportAeronca 11AC · Paradise, TXLoss of engine power for an undetermined reason, and failure of the pilot to maintain sufficient airspeed during the forced landing, which resulted in an inadvertent stall.NTSB FTW89FA089Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601 · New Iberia, LAThe pilot failed to maintain a proper climb immediately after takeoff. Contributing to the accident was excessive manifold pressure indications for the left engine. The pilot's diverted attention in dealing with that condition most probably resulted in the…NTSB FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.NTSB CHI89IA084Incident · No injuriesIncident investigationFinal reportFokker F-27 MK500 · Moline, ILMaterial failure of the landing gear retraction and extension assembly. Inadequate maintenance and troubleshooting procedures in company directives were factors in this incident.NTSB ATL89LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHPilot in command failed to maintain directional control of the aircraft while landing in a gusty crosswind. The crosswind component exceeded the published demonstrated crosswind capability of the airplane.NTSB ATL89LA140Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlotte, NCComplete loss of engine power due to fuel exhaustion. The fuel exhaustion was due to the pilot not assuring an adequate fuel supply for the flight by visual inspection during his preflight inspection. Contributing was the pilot's decision to continue flight…NTSB ANC89IA068Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Cordova, AKFailure of the upper trunion bolt which normally holds the upper portion of the over center down link.NTSB MIA89GA144Accident · 2 fatalFinal reportDouglas C-47 · Summerland Key, FLThe failure of the pilot-in-command to assure proper altitude and clearance was maintained above the terrain and trees. The trees and light condition at dusk were contributing factors.NTSB LAX89LA177Accident · No injuriesLimited investigationFinal reportCessna 310C · Jackson, CAThe failure of the instructor pilot (pilot in command) to reject the takeoff after the loss of power on one engine when sufficient runway remained to stop the aircraft. Contributing to the accident was the disregard of the aircraft manual, failure to use the…NTSB FTW89FA090Accident · 2 fatalField investigationFinal reportCessna 172P · Burnet, TXContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions and the pilot's lack of…NTSB DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.NTSB DEN89LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Bozeman, MTImproper in-flight planning/decision by the pilot which led to his failure to maintain directional control during the landing. Contributing factors were: use of an unfavorable runway, crosswind, and gusts.NTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.NTSB DEN89LA113Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Albuquerque, NMInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during landing roll. Variable and gusting winds are considered a contributing factor.NTSB CHI89IA083Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNFailure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws.NTSB SEA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gerlach, NVA delay by the pilot in aborting the landing and his failure to assure sufficient airspeed for the go-around (aborted landing). A factor related to the accident was: the unsuitable landing area that was selected by the pilot.NTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.NTSB MIA89LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Palmetto, FLThe pilot's selection of the wrong runway for landing along with failure to attain a proper point of touchdown and the failure to perform a go-around.NTSB CHI89LA082Accident · Minor injuriesLimited investigationFinal reportCessna 320D · Wixom, MIPilot's inattention to the fuel system during preflight and inadequate fuel system monitoring throughout the flight.NTSB NYC89LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · Hudson, NYFatigue failure of the right main strut.NTSB LAX89LA176Accident · No injuriesLimited investigationFinal reportBeech 35 · Sierraville, CAThe pilot's attempt to land downwind on the runway and the inability to attain a climb after aborting the landing which resulted in a stall and uncontrolled descent into the ground.NTSB LAX89LA175Accident · No injuriesLimited investigationFinal reportMooney M20E · Julian, CAThe inadequate preflight planning/preparation by the pilot. Contributing to the accident was the loose gravel runway and the fence which the airplane was unable to clear.NTSB CHI89DEP03Accident · No injuriesFinal reportTesmer Glassair SH-2 · Watertown, WILack fuel flow to the engine (fuel starvation) due to an undetermined fuel system problem.NTSB ANC89LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKFailure of the pilot to go-around when he did not attain the proper touchdown point, which required excessive use of brakes to stop on the short landing area.NTSB SEA89LA076Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Milton-Freewtr, ORImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel.NTSB MIA89WA142Accident · No injuriesForeign investigationBeech 65 · Nassau, BahamasNTSB MIA89LA140Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Daytona Beach, FLA loss of engine power for undetermined reasons.NTSB LAX89LA174Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Ramona, CAThe pilot of the other aircraft did not maintain an adequate visual lookout and collided with this Cessna that was parked in the runup area.NTSB ATL89FA139Accident · 5 fatalField investigationFinal reportBeech B24R · Suches, GAThe pilot's flight into known adverse weather, and his failure to maintain clearance above the wooded terrain. The adverse weather condition, high terrain, and trees were related factors.NTSB NYC89FA129Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Herkimer, NYA forced landing in unsuitable terrain due to an internal engine failure. The engine failure sequence was initiated by a failed oil pressure relief spring which had failed in fatigue due to improper plating of the spring. The spring failure caused oil…NTSB MIA89WA139Accident · No injuriesForeign investigationBritten-Norman BN-2A MK-III · Walkers Cay, BahamasNTSB MIA89LA141Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Smyrna Bch., FLThe failure of the pilot to adequately preflight the airplane. Contributing to the accident was the pilot's failure to use the brakes to maintain directional control and poor inspection of the airplane by company maintenance personnel.NTSB NYC89LA131Accident · Serious injuriesLimited investigationFinal reportAdams Unknown · Soleburg, PAThe pilot's inadequate weather evaluation which resulted in delaying the precautionary landing. Factors contributing to the accident included high winds and the lack of restraining devices inside the basket to help the occupants remain inside.NTSB NYC89LA130Accident · No injuriesLimited investigationFinal reportCessna C182Q · Beaver Falls, PAThe pilot failure to properly flare the airplane during landing and the improper recovery from a bounced landing.