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 ANC92GA155Accident · No injuriesFinal reportBell 206B · Fairbanks, AKPoor maintenance and inspection procedures by the contract maintenance personnel, as well as improper maintenance and installation of the fuel line by the contract maintenance personnel. Factors relating to the accident were the turboshaft engine vibrations…Aug 25, 1992 · N83139 · Substantial damageNTSB SEA92LA189Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Concrete, WAThe loss of engine power due to fuel exhaustion, resulting from the IMPR0PER in-flight planning by the pilot in command and his failure to select a proper touchdown point for an emergency forced landing. A factor relating to the accident was the uneven…Aug 24, 1992 · N37667 · Substantial damageNTSB SEA92LA188Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Snoqualmie, WAThe pilot's not maintaining control of the aircraft because of incapacitation resulting from both hypoglycemia/diet and loss of consciousness.Aug 24, 1992 · N71183 · DestroyedNTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.Aug 24, 1992 · N2169A · Substantial damageNTSB NYC92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Coatesville, PAThe pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.Aug 24, 1992 · N37DD · Substantial damageNTSB ANC92LA144Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Nome, AKThe pilot's failure to maintain an adequate altitude.Aug 24, 1992 · N5006M · Substantial damageNTSB ANC92LA143Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Harding Lake, AKThe partial loss of engine power for undetermined causes, and the unsuitable terrain.Aug 24, 1992 · N7887H · Substantial damageNTSB NYC92LA175Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-65 · Suffern, NYThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. Factors related to the accident were the pilot's overconfidence in his abilities, and buzzing.Aug 23, 1992 · N27558 · DestroyedNTSB NYC92FA174Accident · 1 fatalField investigationFinal reportCessna 150M · Union Township, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors related to this accident was night conditions, the pilot's lack of night experience, and the pilot becoming lost and disoriented.Aug 23, 1992 · N714DS · DestroyedNTSB LAX92LA363Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Bakersfield, CALeakage of brake fluid from an unknown source onto the brake lining and drum.Aug 23, 1992 · N3201U · Substantial damageNTSB LAX92LA361Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Morgan Hill, CAA loss of engine power due to carburetor ice and the failure of the pilot to use carburetor heat.Aug 23, 1992 · N707CW · Substantial damageNTSB LAX92LA360Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Big Bear, CAThe pilots decision to attempt crossing a ridge line at an altitude insufficient to allow for contingency actions in the event of an encounter with down drafts or turbulence. Factors in the accident were the high density altitude and the flight's encounter…Aug 23, 1992 · N20BN · DestroyedNTSB FTW92WA231Accident · No injuriesForeign investigationCessna 402B · San Fernando, MexicoAug 23, 1992 · N22SJ · Substantial damageNTSB FTW92LA217Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Farmington, NMTotal loss of engine power due to carburetor ice and the pilot's delayed use of carburetor heat. A factor was unsuitable terrain.Aug 23, 1992 · N8841D · Substantial damageNTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.Aug 23, 1992 · N1672Y · Substantial damageNTSB CHI92LA250Accident · 1 fatalLimited investigationFinal reportBoeing 747-300 · Chicago, ILAn unsafe/hazardous condition that was not identified by the vehicle driver, and an inadequate distance between the airplane and vehicle as the driver drove the vehicle behind the airplane.Aug 23, 1992 · HL746 · No damageNTSB ANC92LA142Accident · No injuriesLimited investigationFinal reportCessna 140 · Wasilla, AKThe partial loss of engine power due to the separation of the right hand exhaust stack. Contributing to the accident was the unsuitable terrain on which the forced landing was made.Aug 23, 1992 · N77073 · Substantial damageNTSB ANC92FA141Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKPilot in command's intentional flight into known adverse weather conditions. Factors relating to the accident were: the pilot's disregard for adverse weather advisory, weather conditions (clouds) and mountainous terrain.Aug 23, 1992 · N9829X · DestroyedNTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.Aug 22, 1992 · N28267 · Substantial damageNTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.Aug 22, 1992 · N3985W · Substantial damageNTSB NYC92LA172Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · West Mifflin, PAThe pilot inadvertently ground looped the airplane which resulted in the main landing gear collapsing. A factor in this accident was the pilot's limited flight time in this make and model airplane.Aug 22, 1992 · N50264 · Substantial damageNTSB MIA92IA166Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71F · Miami, FLFailure of the aircraft operator maintenance personnel to adequately lubricate and seal the main landing gear bogie beam swivel joint as required by manufacturer and operator maintenance program requirements. This allowed moisture to enter the swivel joint…Aug 22, 1992 · N748UP · Minor damageNTSB LAX92LA359Accident · Minor injuriesLimited investigationFinal reportTBM TBM 700 · So. Lake Tahoe, CAThe failure of both pilots to adequately anticipate and compensate for the variable cross wind condition, and, the pilot in command's inadequate supervision of the flight. A factor in the accident was the left seat pilot's limited total experience and…Aug 22, 1992 · N339W · DestroyedNTSB DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.Aug 22, 1992 · N735JN · Substantial damageNTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.Aug 22, 1992 · N15672 · Substantial damageNTSB ANC92LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Chicken, AKThe pilot's selection of unsuitable terrain. Contributing factors were the pilot inadvertently became lost/disoriented, her lack of total expereince, her lack of familiarity with the geographical area, the poor lighting condition (dusk), and the weather…Aug 22, 1992 · N60725 · Substantial damageNTSB ANC92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Togiak, AKThe pilot's improper preflight planning/decision, and his delay in aborting the takeoff. Contributing factors were the berm and the standing water on the runway.Aug 22, 1992 · N8402S · Substantial damageNTSB ANC92LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot's improper preflight planning/preparation, his improper compensation for wind conditions, and his failure to maintain directional control during the takeoff run. Contributing to the accident was the crosswind.Aug 22, 1992 · N63805 · Substantial damageNTSB ANC92LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150-F · Whittier, AKThe pilot's improper in flight planning/decision, and his inadvertent VFR flight into IMC weather conditions. Contributing factors were the pilot's lack of total experience with this type operation, and the mountainous terrain.Aug 22, 1992 · CGVJM · Substantial damageNTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.Aug 21, 1992 · N78BS · Substantial damageNTSB CHI92LA251Accident · No injuriesLimited investigationFinal reportCessna 182P · Ephraim, WIThe pilot selected the wrong runway for landing.Aug 21, 1992 · N1368S · Substantial damageNTSB CHI92LA249Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Marshall, INThe pilot's failure to maintain control of the helicopter due to his alcoholic impairment of efficiency and judgement.Aug 21, 1992 · N203SD · DestroyedNTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.Aug 21, 1992 · N2353L · Substantial damageNTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.Aug 21, 1992 · N527HA · Substantial damageNTSB SEA92LA184Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Mattawa, WALoss of engine power due to fuel contamination as a result of inadequate maintenance by the operator. A factor contributing to the accident was soft terrain.Aug 20, 1992 · N28951 · DestroyedNTSB NYC92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bedford, MAThe pilot's loss of airplane control during the flare, resulting in porpoising and subsequent hard landing.Aug 20, 1992 · N8371H · Substantial damageNTSB LAX92LA362Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Irwindale, CAThe pilot's misjudgment of the landing flare during a practice autorotation.Aug 20, 1992 · N595H · Substantial damageNTSB FTW92FA215Accident · Minor injuriesField investigationFinal reportBell XV-15 301 · Arlington, TXInadequate maintenance and inspection which resulted in a disconnected proprotor governor linkage.Aug 20, 1992 · N702NA · DestroyedNTSB ATL92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oviedo, FLThe failure of the dual student to properly flare the aircraft during the landing attempt, and the flight instructor's failure to perform remedial action to prevent the hard landing.Aug 20, 1992 · N2662R · Substantial damageNTSB NYC92LA179Accident · No injuriesLimited investigationFinal reportBenson-Callaway B-80 · Paducah, KYThe loss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain.Aug 19, 1992 · N852DC · Substantial damageNTSB NYC92LA170Accident · No injuriesLimited investigationFinal reportGerald Barker Quicky 2 · Altoona, PAAn onground collision with a VASI light box after the tailwheel strut broke upon touchdown and the pilot lost directional control.Aug 19, 1992 · N244GB · Substantial damageNTSB NYC92LA169Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Put-In-Bay, OHThe pilot's improper use of carburetor heat, resulting in a loss of engine power and subsequent forced landing in trees.Aug 19, 1992 · N18176 · Substantial damageNTSB NYC92LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Salem, CTThe pilot's inaccurate fuel calculations and his improper decision to takeoff with a known limited fuel supply resulting in fuel exhaustion and subsequent forced landing. Factors related to the accident were the pilot's lack of total flight experience and his…Aug 19, 1992 · N2519B · Substantial damageNTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.Aug 19, 1992 · N731PV · Substantial damageNTSB LAX92LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Laveen, AZThe failure of the pilot to maintain directional control of the aircraft during the landing roll.Aug 19, 1992 · N5363 · Substantial damageNTSB LAX92LA357Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Jackpot, NVThe pilot allowing himself to become distracted while searching for a landing light switch during a critical phase of flight and the resultant failure to maintain control of the aircraft. Factors in the accident were the dark night light conditions and the…Aug 19, 1992 · N93336 · Substantial damageNTSB FTW92LA214Accident · No injuriesLimited investigationFinal reportCessna A185F · Amelia, LAThe pilot's selection of unsuitable terrain for takeoff.Aug 19, 1992 · N1867Q · Substantial damageNTSB FTW92DPG15Accident · No injuriesFinal reportBell-Transworld 47G-2 · Birdeye, ARFuel contamination. A factor was the high density altitude.Aug 19, 1992 · N9238Z · Substantial damageNTSB CHI92LA245Accident · No injuriesLimited investigationFinal reportCessna 182A · Colfax, INThe pilot's selection of the wrong runway and a premature lift off. Factors were uphill terrain and unfavorable (quartering/tail) wind.Aug 19, 1992 · N5197D · Substantial damageNTSB ATL92FA162Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Lawrenceville, GAThe pilot's failure to maintain aircraft control which resulted in an inadvertent stall, and his improper execution of emergency procedures. Factors were the pilot's overconfidence, his inadequate preflight inspection when he failed to drain the gascolator,…Aug 19, 1992 · N5640W · Substantial damage