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 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.Feb 27, 1995 · N57GE · DestroyedNTSB 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.Feb 27, 1995 · N369AE · No damageNTSB 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…Feb 27, 1995 · N970CC · Substantial damageNTSB 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.Feb 26, 1995 · N53893 · Substantial damageNTSB 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.Feb 26, 1995 · N28SQ · No damageNTSB 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.Feb 26, 1995 · N9198L · DestroyedNTSB 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.Feb 26, 1995 · N5613P · Substantial damageNTSB 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…Feb 26, 1995 · GAWNM · No damageNTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.Feb 25, 1995 · N4269E · Substantial damageNTSB 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.Feb 25, 1995 · N49335 · Substantial damageNTSB 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.Feb 25, 1995 · N6291P · Substantial damageNTSB 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.Feb 25, 1995 · N6479H · DestroyedNTSB FTW95LA123Accident · No injuriesLimited investigationFinal reportCessna 180J · El Paso, TXThe pilot's failure to maintain directional control during the landing roll.Feb 25, 1995 · N9900N · Substantial damageNTSB 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.Feb 25, 1995 · N872MM · Substantial damageNTSB 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.Feb 25, 1995 · N732TU · DestroyedNTSB 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.Feb 25, 1995 · N28815 · Substantial damageNTSB 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.Feb 24, 1995 · N2277T · Substantial damageNTSB 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.Feb 24, 1995 · N3344V · Substantial damageNTSB NYC95LA062Accident · No injuriesLimited investigationFinal reportCessna 172L · Saratoga Spgs, NYThe pilot's poor judgment in attempting a flight under the existing wind conditions.Feb 24, 1995 · N7002Q · Substantial damageNTSB 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.Feb 24, 1995 · N13229 · Substantial damageNTSB 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.Feb 24, 1995 · N7972Y · DestroyedNTSB 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.Feb 23, 1995 · N4021Z · Substantial damageNTSB 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…Feb 23, 1995 · N7142U · Substantial damageNTSB 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.Feb 23, 1995 · N731CZ · Substantial damageNTSB FTW95LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's delayed landing flare and the improper bounced landing recovery.Feb 23, 1995 · N737TC · Substantial damageNTSB 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.…Feb 23, 1995 · N100BL · Substantial damageNTSB 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.Feb 23, 1995 · N757ZQ · Substantial damageNTSB 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.Feb 23, 1995 · N7127X · Substantial damageNTSB 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.Feb 23, 1995 · N6470P · Substantial damageNTSB 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…Feb 22, 1995 · N20SP · DestroyedNTSB 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.Feb 21, 1995 · N51920 · Substantial damageNTSB 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.Feb 21, 1995 · N66JE · Substantial damageNTSB 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.Feb 20, 1995 · N8226D · Substantial damageNTSB MIA95LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Caribbean SeaA total loss of engine power for undetermined reasons.Feb 20, 1995 · N598PR · DestroyedNTSB 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…Feb 20, 1995 · N7172Z · Substantial damageNTSB 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.Feb 20, 1995 · N2688J · DestroyedNTSB 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.Feb 20, 1995 · N28003 · 2 aircraft · Minor damageNTSB 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…Feb 20, 1995 · N1309X · Substantial damageNTSB 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.Feb 20, 1995 · N34958 · Substantial damageNTSB 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.Feb 20, 1995 · N5255Q · Substantial damageNTSB 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.Feb 19, 1995 · N738NQ · Substantial damageNTSB 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.Feb 19, 1995 · N9795L · DestroyedNTSB LAX95LA117Accident · No injuriesLimited investigationFinal reportCessna T210F · Phalen, CAthe pilot's decision to continue the flight with a known mechanical discrepancy in the brake system.Feb 19, 1995 · N6186R · Substantial damageNTSB 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…Feb 19, 1995 · N9036T · Substantial damageNTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.Feb 18, 1995 · N115EZ · Substantial damageNTSB 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.Feb 18, 1995 · N45325 · Substantial damageNTSB 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.Feb 18, 1995 · N376MQ · Minor damageNTSB 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.Feb 18, 1995 · N833KS · Substantial damageNTSB CHI95LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Cotton, MNthe pilot's failure to gain sufficient clearance over the trees during the aborted landing.Feb 18, 1995 · N52172 · Substantial damageNTSB 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.Feb 18, 1995 · N79569 · Substantial damage