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 FTW90LA096Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · E. Island Blk15The loss of continuity in the compressor section of the engine due to a fatique failure of the spur adapter gear shaft.Apr 17, 1990 · N1071A · No damageNTSB ANC90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Deadhorse, AKInadequate maintenance and inspection of the nose baggage door.Apr 17, 1990 · N4109E · Substantial damageNTSB MKC90LA086Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Eden Prairie, MNDirectional control was not maintained by the pilot in command.Apr 16, 1990 · N6182R · Substantial damageNTSB MIA90FA105Accident · No injuriesField investigationFinal reportEmbraer EMB-110 · Fort Lauderdale, FLThe pilot in command's failure to maintain an adequate visual look-out due to his self imposed pressure of taxiing, completing cockpit checklists and obtaining a clearance at the same time.Apr 16, 1990 · N64CZ · Substantial damageNTSB FTW90LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Albany, TXThe pilot's failure to maintain flying speed which resulted in an uncontrol touchdown and collision with objects.Apr 16, 1990 · N93070 · Substantial damageNTSB CHI90DEV03Accident · Minor injuriesFinal reportBellanca 8KCAB · Lawrenceville, ILThe student pilot failure to maintain flying speed. Contributing to the accident was the flight instructor in that the instructor allowed the student to let the airspeeed dissipate below stall speed.Apr 16, 1990 · N50671 · Substantial damageNTSB ATL90LA098Accident · 1 fatalLimited investigationFinal reportCessna 150H · N. Myrtle Beach, SCThe pilot's improper course reversal procedure which resulted in a stall at a low altitude precluding a recovery before water impact.Apr 16, 1990 · N22953 · Substantial damageNTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.Apr 16, 1990 · N6683K · Substantial damageNTSB ANC90LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Bethel, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadeqaute supply of fuel.Apr 16, 1990 · N2214T · Substantial damageNTSB ANC90LA057Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Bethel, AKPilot-in-command's failure to maintain control of the helicopter during touchdown.Apr 16, 1990 · N703H · Substantial damageNTSB ANC90FA061Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Egegik, AKFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in a stall.Apr 16, 1990 · N95982 · Substantial damageNTSB SEA90LA068Accident · 1 fatalLimited investigationFinal reportTruckee Meadows Tierra II · Moscow, IDThe pilot did not maintain a proper airspeed during the climb to cruise.Apr 15, 1990 · N52744 · DestroyedNTSB LAX90LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Soledad, CAPilot's failure to maintain directional control during takeoff. Contributing factors were the gusty wind and the crosswind conditions.Apr 15, 1990 · N9394C · Substantial damageNTSB FTW90LA095Accident · No injuriesLimited investigationFinal reportHughes 369HS · Junction, TXThe pilot in command's inadequate execution of the autorotation following a engine failure which resulted from his failure to refuel the aircraft with the proper grade of fuel when he ran short during the flight.Apr 15, 1990 · N9138F · Substantial damageNTSB DEN90FA092Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Wendover, UTThe pilot's loss of control of the airplane due to spatial disorientation. Contributing factor(s) was: the lack of surface reference while taking off over a sparsely populated area under dark night light conditions.Apr 15, 1990 · N6401P · DestroyedNTSB ATL90LA097Accident · No injuriesLimited investigationFinal reportCessna T210 · Lafayette, GAThe pilot's failure to properly manage his fuel supply, which resulted in a loss of engine power, due to fuel starvation.Apr 15, 1990 · N761YK · Substantial damageNTSB ATL90FA099Accident · No injuriesField investigationFinal reportAirship Industries Airship 600 · Creswell, NCThe failure of the electronic ignition units as the Airship traversed the directional antenna beam of a high intensity radiated electromagnetic field (hirf). Factors related to the accident were: the unfavorable wind and the lack of hirf certification…Apr 15, 1990 · N602SK · Substantial damageNTSB ATL90DKG03Accident · No injuriesFinal reportCorben BABY-ACE · Griffin, GAAn improper fuel system (installed by the home builder), and continued operation of the aircraft with a known deficiency, which resulted in fuel starvation.Apr 15, 1990 · N1034C · Substantial damageNTSB ANC90LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's improper planning/decision, which resulted in a nose-over of the aircraft when it encountered a wave from a boat during the takeoff run.Apr 15, 1990 · N6MX · Substantial damageNTSB MKC90LA085Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Pleasant Grove, ARImproper use of carburetor heat by the pilot, which resulted in carburetor icing. The weather (carburetor icing condition) was a related factor.Apr 14, 1990 · N1902M · Substantial damageNTSB MKC90FA082Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bois D'Arc, MOInadvertent flight by the pilot into instrument meteorological conditions (IMC), and his spatial disorientation, which resulted in loss of aircraft control. Factors related to the accident were: the pilot's inadequate weather evaluation, darkness, low…Apr 14, 1990 · N6KG · DestroyedNTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.Apr 14, 1990 · N2238W · DestroyedNTSB ANC90LA056Accident · No injuriesLimited investigationFinal reportBell 206B · Drift River, AKThe pilot failed to maintain control of the helicopter during lift-off.Apr 14, 1990 · N1086Z · Substantial damageNTSB SEA90FA066Accident · 2 fatalField investigationFinal reportMooney M20K · Carson City, NVThe pilot failed to maintain airspeed during takeoff. A contributing factor was the high density altitude.Apr 13, 1990 · N231NB · DestroyedNTSB SEA90FA065Accident · Serious injuriesField investigationFinal reportCessna 172M · Incline Village, NVImproper in-flight planning/decision by the instructor pilot (CFI), and his failure to maintain adequate altitude and clearance from obstructions. Factors related to the accident were: mountainous terrain, high density altitude, and the trees (obstructions).Apr 13, 1990 · N9021H · DestroyedNTSB MKC90DCQ01Accident · 2 fatalFinal reportDaniels BD-4 · Wichita, KSThe pilot failed to maintain flying speed which resulted in an inadvertent stall/spin resulting in collision with terrain.Apr 13, 1990 · N31481 · DestroyedNTSB LAX90LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hanford, CAThe failure of the pilot in command to maintain a sufficient airspeed for the wind conditions encountered during the attempted landing.Apr 13, 1990 · N7309G · Substantial damageNTSB LAX90FA145Accident · Serious injuriesField investigationFinal reportCessna T207 · Grand Canyon, AZImproper adjustment of the turbo-charger absolute pressure controller, and improper manipulation of the power plant controls by the pilot during the go-around. Factors related to the accident were: failure of company management to properly train the pilot in…Apr 13, 1990 · N91081 · DestroyedNTSB FTW90DRD05Accident · No injuriesFinal reportSchweizer G-164B · Reeves, LALoss of engine power due to a frozen rocker arm.Apr 13, 1990 · N48455 · Substantial damageNTSB CHI90LA111Accident · No injuriesLimited investigationFinal reportCessna 172RG · Romeoville, ILThe failure of the instructor to correct a loss of directional control during a landing roll in a timely manner.Apr 13, 1990 · N9694B · Substantial damageNTSB ATL90LA096Accident · No injuriesLimited investigationFinal reportCessna 172A · Villa Rica, GAFuel starvation to the engine, initiated by the combination of a blocked fuel tank vent line and a malfunctioning fuel filler cap. A factor in the accident was the pilot's inadequate preflight inspection, in that he did not detect the fuel vent line blockage.Apr 13, 1990 · N7677T · Substantial damageNTSB ATL90DKJ05Accident · Minor injuriesFinal reportHood Quickie · Altoona, ALThe pilot's inadequate preflight and a blocked fuel vent, which resulted in fuel starvation.Apr 13, 1990 · N36RH · Substantial damageNTSB ANC90LA060Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKThe pilot-in-command's failure to maintain the proper altitude.Apr 13, 1990 · N9964M · Substantial damageNTSB ANC90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Knik Clacier, AKA foreign object (tool) had jammed the aileron controls to the right as the pilot was maneuvering the aircraft for a low approach to a strip.Apr 13, 1990 · N4904M · Substantial damageNTSB ANC90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKImproper installation of the fuel valve.Apr 13, 1990 · N40872 · Substantial damageNTSB SEA90LA067Accident · Serious injuriesLimited investigationFinal reportBecker Bensen B8M · Burlington, WAThe pilot's failure to maintain clearance from the propeller.Apr 12, 1990 · N87917 · No damageNTSB MKC90LA084Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Branson, MOA disconnected throttle linkage that was inadequately inspected.Apr 12, 1990 · N84055 · Substantial damageNTSB MKC90LA083Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Harrisburg, ARFailure of the generator, and failure of the pilot to maintain rotor RPM.Apr 12, 1990 · N4779U · Substantial damageNTSB MIA90LA104Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Stuart, FLThe instructor pilot's failure to correct the loss of airspeed resulting from the student's incorrect control input while on approach to land.Apr 12, 1990 · N109SA · Substantial damageNTSB LAX90LA146Accident · No injuriesLimited investigationFinal reportBeech F33A · Yuba City, CAA dog suddenly running onto the active runway in front of the aircraft resulted in a collision and substantial airframe damage.Apr 12, 1990 · N4497S · Substantial damageNTSB ATL90DKJ03Accident · Minor injuriesFinal reportJolly Bakeng Duce · Brownsboro, ALFailure of the pilot to maintain the reference speed on approach and establish a proper glidepath.Apr 12, 1990 · N72WJ · Substantial damageNTSB ANC90FA053Accident · No injuriesField investigationFinal reportCessna 172-K · Anchorage, AKPilot-in-command used poor judgement when he elected to take off on rough & uneven frozen lake which resulted in a failed nose ski.Apr 12, 1990 · N46410 · Substantial damageNTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.Apr 11, 1990 · N71779 · DestroyedNTSB MIA90LA103Accident · No injuriesLimited investigationFinal reportSwing Velocity RG · Wimauma, FLDelamination of a portion of one of the wooden propeller blades at a knot, resulting in severe vibration and necessitating a forced landing.Apr 11, 1990 · N125V · Substantial damageNTSB LAX90LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Banning, CAFailure of the student pilot to ascertain the wind direction resulting in a downwind landing.Apr 11, 1990 · N24376 · DestroyedNTSB CHI90LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Manistique, MIThe pilot allowing the airplane to run out of fuel.Apr 11, 1990 · N42417 · DestroyedNTSB LAX90LA142Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chico, CAFuel starvation due to unporting of the fuel pick up in the fuel tank selected for the takeoff.Apr 10, 1990 · N76918 · Substantial damageNTSB LAX90LA140Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Auburn, CAPilot failed to attain the proper touch down point and the remedial action was improper. Contributing to this accident was that the pilot allowed the aircraft to porpoise during the landing rollout.Apr 10, 1990 · N28277 · Substantial damageNTSB FTW90FA094Accident · 1 fatalField investigationFinal reportBeech B35-C33A · Le Compte, LAThe pilot's continuation of VFR flight into IMC. Factors were the pilot's failure to obtain a pre-flight weather brief and his inadequate evalution of existing weather.Apr 10, 1990 · N7968M · DestroyedNTSB FTW90FA093Accident · 1 fatalField investigationFinal reportMooney M-20J · Inola, OKThe pilot's decision to conduct the flight into known adverse weather and his inability to maintain control of the airplane due to spatial disorientation. Factors were the dark night conditions and thunderstorms.Apr 10, 1990 · N526L · Destroyed