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 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB ANC92LA144Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Nome, AKThe pilot's failure to maintain an adequate altitude.NTSB ANC92LA143Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Harding Lake, AKThe partial loss of engine power for undetermined causes, and the unsuitable terrain.NTSB 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.NTSB 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.NTSB LAX92LA363Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Bakersfield, CALeakage of brake fluid from an unknown source onto the brake lining and drum.NTSB 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.NTSB 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…NTSB FTW92WA231Accident · No injuriesForeign investigationCessna 402B · San Fernando, MexicoNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.NTSB CHI92LA251Accident · No injuriesLimited investigationFinal reportCessna 182P · Ephraim, WIThe pilot selected the wrong runway for landing.NTSB 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.NTSB 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.NTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.NTSB 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.NTSB 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.NTSB LAX92LA362Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Irwindale, CAThe pilot's misjudgment of the landing flare during a practice autorotation.NTSB FTW92FA215Accident · Minor injuriesField investigationFinal reportBell XV-15 301 · Arlington, TXInadequate maintenance and inspection which resulted in a disconnected proprotor governor linkage.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB LAX92LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Laveen, AZThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB 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…NTSB FTW92LA214Accident · No injuriesLimited investigationFinal reportCessna A185F · Amelia, LAThe pilot's selection of unsuitable terrain for takeoff.NTSB FTW92DPG15Accident · No injuriesFinal reportBell-Transworld 47G-2 · Birdeye, ARFuel contamination. A factor was the high density altitude.NTSB 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.NTSB 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,…