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 LAX95LA123Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Jean, NVthe pilot's decision to fly in known adverse weather conditions which resulted in a wind shear encounter at low altitude during the takeoff initial climb.NTSB FTW95IA124Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Austin, TXThe failure of the misrouted rudder control cable due to improper installation during scheduled replacement to comply with an airworthiness directive.NTSB CHI95LA093Accident · No injuriesLimited investigationFinal reportBell 206L · Maryland Hts, MOFatigue failure of two attachment bolts that connected the driveshaft to the geared portion of a driveshaft coupling. Factors relating to the accident were: inadequate maintenance, uneven terrain in the touchdown area for the forced landing, and the…NTSB LAX95LA122Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · San Jose, CAthe student pilot's failure to maintain directional control of the conventional gear aircraft during an aborted landing attempt. Factors in the accident were the student's high and fast approach and his failure to achieve the proper touchdown point.NTSB LAX95LA121Accident · 1 fatalLimited investigationFinal reportThunder and Colt GA42 · Hayward, CAthe pilot's decision to operate the blimp with a known and unresolved deficiency in the electrical system, which led to a loss of the flight controls and the pilot's improper remedial actions after the blimp came to rest on the ground.NTSB LAX95FA119Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · San Jose, CAThe pilot's improper climb attitude which resulted in a momentary loss of engine power due to fuel starvation.NTSB FTW95LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Carlsbad, NMFuel exhaustion engine power loss due to a leak in the fuel system. Factors were dark night conditions and the lack of suitable terrain for the forced landing.NTSB CHI95IA095Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Chicago, ILthe North Local Controller's failure to issue a clearance which would ensure separation between the two airplanes and the North Local Control Monitor's failure to adequately back up the controller. Factors were the complexity of the airport operations and…NTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.NTSB SEA95LA056Accident · No injuriesLimited investigationFinal reportPitts S-2B · Spokane, WAFatigue failure of the crankshaft. Factors were the soft terrain and the pilot/owner's failure to conduct recurring crankshaft inspections recommended by the manufacturer.NTSB NYC95LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · North Bergen, NJThe pilot's inadequate in-flight planning which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB LAX95FA120Accident · 1 fatalField investigationFinal reportCessna 207A · Kotzebue, AKthe pilot's decision to enter a box canyon area at an altitude inadequate to maintain terrain clearance. The pilot's lack of mountain flying experience was a factor in this accident.NTSB FTW95LA123Accident · No injuriesLimited investigationFinal reportCessna 180J · El Paso, TXThe pilot's failure to maintain directional control during the landing roll.NTSB FTW95LA122Accident · Minor injuriesLimited investigationFinal reportMorrison, Marvin E. RV-4 · Brighton, COA total loss of power for unknown reasons. A factor was the lack of suitable terrain for a forced landing.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB ATL95LA055Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Salisbury, NCThe separation of the oil line to the oil cooler which resulted in a loss of engine oil and subsequent engine seizure.NTSB SEA95GA062Accident · No injuriesFinal reportBell 206 · Dillon, MTThe pilot's selection of a landing site that was not suitable to support the weight of the helicopter. Factors include terrain covered with soft snow.NTSB NYC95LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Shadyside, OHThe loss of oil pressure, which resulted in the number six connecting rod failure and penetration through the crankcase.NTSB NYC95LA062Accident · No injuriesLimited investigationFinal reportCessna 172L · Saratoga Spgs, NYThe pilot's poor judgment in attempting a flight under the existing wind conditions.NTSB NYC95LA061Accident · No injuriesLimited investigationFinal reportCessna 172M · West Seneca, NYThe pilot's improper planning/decision to attempt a takeoff on a narrow icy runway with crosswind conditions, which resulted in the loss of control of the airplane, impact with a snow bank, and a nose over.NTSB ATL95FA054Accident · 2 fatalField investigationFinal reportPiper PA-30B · Franklin, NCThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was sunglare.NTSB SEA95LA055Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34AG · Moses Lake, WAThe pilot-in-command's failure to maintain adequate altitude above the terrain. Factors include his diverted attention and attempted maneuver to avoid obstructions.NTSB MIA95LA080Accident · No injuriesLimited investigationFinal reportMooney M20E · Mclain, MSThe improper reassembly of the servo fuel injector during overhaul by maintenance personnel. This resulted in a total loss of engine power during cruise flight due to fuel starvation, forced landing, and subsequent on-ground collision with a fixed object…NTSB LAX95LA118Accident · No injuriesLimited investigationFinal reportCessna A-188B · Elmira, CAthe pilot's failure to maintain control of the aircraft after an inadvertent encounter with the wake turbulence from a preceding agricultural aircraft while maneuvering at low altitude.NTSB FTW95LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's delayed landing flare and the improper bounced landing recovery.NTSB FTW95LA119Accident · No injuriesLimited investigationFinal reportBeech 60 · Santa Rosa, NMThe failure of the right engine's turbocharger resulting in oil starvation and subsequent failure of the #5 connecting rod which penetrated the crankcase, and the failure of the left engine's turbocharger resulting in the loss of power on both engines.…NTSB CHI95LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Owosso, MIthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the snow bank.NTSB CHI95LA092Accident · No injuriesLimited investigationFinal reportCessna 150A · Grant, MIThe student pilot's decision to intentionally land downwind and his failure to maintain directional control of the aircraft during landing roll. The pilot's lack of experience and the tailwind were contributing factors.NTSB ATL95LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookwood, ALThe pilot's failure to lean the fuel mixture, stop at the first destination to refuel, and his incorrect fuel consumption calculations.NTSB NYC95GA060Accident · 4 fatalFinal reportEurocopter AS-350-B · Cambridge, MA1) The Massachusetts state police (msp) management's failure to provide adequate oversight of its air wing; 2) fuel contamination and obstructed fuel injector nozzles, due to inadequate fuel storage and storage requirements by the msp, resulting in a loss of…NTSB LAX95LA133Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAthe pilot's use of an excessive approach speed and glidepath angle and his improper bounced landing recovery technique.NTSB FTW95LA127Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · Denver, COAn oxygen leak at the oxygen system pressure reducer-regulator assembly, resulting in a crew compartment fire.NTSB NYC95LA059Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Millbrook, NYThe pilot's failure to manually extend the landing gear which resulted in the landing gear collapsing. A factor was the intermittent loss of electrical power.NTSB MIA95LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Caribbean SeaA total loss of engine power for undetermined reasons.NTSB MIA95LA078Accident · No injuriesLimited investigationFinal reportHughes 500C · Key Largo, FLThe pilot's misjudgment of altitude and failure to apply collective cushioning pitch during an autorotation resulting in a hard landing. Contributing to the accident was a total loss of engine power due to a loose coupling B-nut on the pneumatic fuel control…NTSB LAX95LA116Accident · No injuriesLimited investigationFinal reportCessna 150G · Carefree, AZthe pilot's premature retraction of the flaps and failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush.NTSB LAX95LA114Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Pacifica, CAFailure of the Grumman pilot to maintain visual contact and clearance from the citabria, while overtaking that aircraft. Factors relating to the accident were: the hazy sky condition and the Grumman pilot's diverted attention to other traffic.NTSB LAX95LA113Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Sonoma, CAthe pilot's failure to maintain an adequate visual lookout for obstructions during initial climb. Factors which contributed to the accident were the pilot's inadequate preflight inspection, and his decision to fly with an inadequately cleaned bubble which…NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.NTSB CHI95LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Washington, MOthe CFI's failure to verify the fuel quantity prior to takeoff which resulted in fuel exhaustion. Factors related to the accident were the student's misjudgment of the fuel quantity and the soft terrain.NTSB SEA95LA054Accident · No injuriesLimited investigationFinal reportCessna TR182 · Bountiful, UTThe pilot's failure to attain proper runway alignment. Factors in the accident were: the dark night conditions and inadequate maintenance of the runway lighting system.NTSB NYC95LA057Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Warwick, NYthe pilot allowed the airplane to get too low on the approach, during a simulated engine out landing, which resulted in impacting high bushes, and landing short of the runway.NTSB LAX95LA117Accident · No injuriesLimited investigationFinal reportCessna T210F · Phalen, CAthe pilot's decision to continue the flight with a known mechanical discrepancy in the brake system.NTSB LAX95LA111Accident · No injuriesLimited investigationFinal reportCessna 182C · Novato, CAThe pilot's failure to maintain a proper base leg alignment while flying in the traffic pattern and his misjudged distance and altitude during the approach. A factor which contributed to the accident was the dark nighttime lighting condition which reduced the…NTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.NTSB SEA95FA052Accident · 2 fatalField investigationFinal reportCessna 150M · Burley, IDThe failure of the dual student to maintain airspeed while maneuvering, and the flight instructor's inadequate supervision.NTSB MIA95IA077Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · St. ThomasInadequate application of sealant on the right main landing gear shock absorber cylinder nut, and inadequate quality control by the manufacturer.NTSB CHI95LA091Accident · No injuriesLimited investigationFinal reportBeech 23 · Hutchinson, KSinadequate preflight planning by the pilot. Contributing factors to this accident were the pilot selecting the wrong runway for takeoff and the tailwind condition.NTSB CHI95LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Cotton, MNthe pilot's failure to gain sufficient clearance over the trees during the aborted landing.NTSB CHI95LA088Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIdelayed remedial action by the flight instructor. Factors in the accident were the student pilot not maintaining directional control once airborne.