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 ATL99FA044Accident · 2 fatalField investigationFinal reportBeech 300 · Cullman, ALThe pilot's failure to adhere to the missed approach procedure resulting in a collision with terrain. Contributing factors were fog and the rotorcraft rated pilot's lack of fixed wing certification/experience.Jan 14, 1999 · N780BF · DestroyedNTSB NYC99LA235Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · New York, NYInadequate counterbalancing to compensate for the weight of the cargo door.Jan 13, 1999 · N785AT · No damageNTSB ATL99LA043Accident · Minor injuriesLimited investigationFinal reportTrohoski VARI-EZE · Tupelo, MSThe pilot's improper flare and compensation for wind conditions upon landing. Factors in the accident were the pilot's inadequate recurrent training and lack of experience with the airplane.Jan 13, 1999 · N721NT · Substantial damageNTSB ATL99LA042Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Hallandale Beac, FLThe loss of engine power for undetermined reasons.Jan 13, 1999 · N5458A · Substantial damageNTSB ANC99LA024Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Anchorage, AKA frozen brake.Jan 13, 1999 · N9190D · Substantial damageNTSB CHI99LA064Accident · No injuriesLimited investigationFinal reportGulfstream 695A · Wheeling, ILThe pilot-in-command (CFI)'s poor in-flight planning and decision making, and his inadequate supervision of the dual student. Factors were the tailwind condition, icing conditions, and the dual student's improper flare.Jan 12, 1999 · N20GT · Substantial damageNTSB ATL99LA041Accident · No injuriesLimited investigationFinal reportCessna 172 · Centre, ALThe pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.Jan 12, 1999 · N6700A · Substantial damageNTSB ANC99LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's continued flight into adverse weather conditions. Factors associated with the accident were freezing rain, an accumulation of ice on the wings and ailerons, and diminished directional control.Jan 12, 1999 · N19TA · Substantial damageNTSB NYC99FA047Accident · 1 fatalField investigationFinal reportCessna 310R · Kearny, NJa loss of elevator control for undetermined reasons.Jan 11, 1999 · N87365 · DestroyedNTSB LAX99LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Arlington, AZThe flight instructor's inadequate supervision of his student and his failure to initiate timely remedial action. Contributing factors were the student's failure to maintain the proper glidepath under the existing downdraft condition, the flight instructor's…Jan 11, 1999 · N4129S · DestroyedNTSB CHI99LA063Accident · No injuriesLimited investigationFinal reportBeech BE-C-45H · St. Joseph, MOthe pilot not maintaining directional control during the landing rollout. A factor in this accident was the patchy snow on the runway.Jan 11, 1999 · N165ZA · Substantial damageNTSB LAX99LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Tucson, AZThe student pilot's inadvertent activation of the right heel brake on the conventional geared aircraft, which resulted in a loss of directional control and an inadvertent ground loop. A contributing factor was inadequate supervision.Jan 10, 1999 · N8980D · Substantial damageNTSB FTW99LA066Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway, ARThe loss of engine power due to carburetor ice during the approach to land. A factor was the lack of suitable terrain for the forced landing.Jan 10, 1999 · N23303 · Substantial damageNTSB ANC99LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's attempted flight into adverse weather. Factors associated with the accident were the pilot's inadequate evaluation of the weather conditions, icing conditions, and an inadvertent stall.Jan 10, 1999 · N8373L · Substantial damageNTSB ANC99FA021Accident · Minor injuriesField investigationFinal reportCessna 207 · Quinhagak, AKLoss of engine power due to fracture of the engine crankshaft, and the manufacturer's improper manufacturing procedure during engine assembly. Factors associated with the accident were the manufacturer's inadequate quality control standards, trees, and…Jan 10, 1999 · N6312H · Substantial damageNTSB SEA99FA028Accident · 2 fatalField investigationFinal reportPacific Aviation Composites LC 40-550FG · Portland, ORAircraft control was not maintained and the pilot's lack of total experience in type operation. Weather conditions reported ceilings below approach/landing minimums and a dark night condition were factors.Jan 9, 1999 · N141LC · DestroyedNTSB CHI99LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILthe pilot's failure to maintain proper runway alignment during the landing flare. A factor related to the accident was the snowbank which the airplane contacted.Jan 9, 1999 · N25787 · Substantial damageNTSB NYC99LA048Accident · No injuriesLimited investigationFinal reportCessna 310R · Allentown, PAThe pilot's improper decision to reduce too much power during the landing flare.Jan 8, 1999 · N31UV · Substantial damageNTSB FTW99LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Madisonville, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Jan 8, 1999 · N66464 · Substantial damageNTSB SEA99FA027Accident · 4 fatalField investigationFinal reportBeech 58P · Yamhill, ORThe pilot's failure to maintain clearance from hilly terrain while maneuvering below a low ceiling. Factors include a dark night, a low ceiling, fog, and hilly terrain.Jan 7, 1999 · N700LF · DestroyedNTSB MIA99GA064Accident · Serious injuriesFinal reportCessna U206G · Homestead, FLThe intentional low altitude flight/maneuver by the pilot-in-command and his disregard of the altitude clearance with terrain resulting in the inflight collision with water during the dark night. Contributing to the accident was the lack of U.S. Customs…Jan 7, 1999 · N756XQ · DestroyedNTSB ATL99LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Palmetto, FLThe failure of the wheel fairing attach bolts that resulted in the loss of control during the landing roll when the fairing became lodged under the left wheel.Jan 7, 1999 · N1231K · Substantial damageNTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.Jan 6, 1999 · N605HA · Substantial damageNTSB MIA99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Perry, GAThe maintenance personnel incorrect adjustment of the intake and exhaust valves resulting in the induction system fire and subsequent loss of engine power.Jan 6, 1999 · N4542Z · Substantial damageNTSB CHI99LA061Accident · No injuriesLimited investigationFinal reportBeech BE-V35B · Olathe, KSThe pilot's continued flight into adverse weather that resulted in structural icing and subsequently an aerodynamic stall on landing flare. A factor was the pilot's inadequate weather evaluation .Jan 6, 1999 · N740T · Substantial damageNTSB CHI99LA059Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Plymouth, INthe pilot's failure to maintain directional control of the airplane while landing. Factors associated with the accident were the tailwind condition and the pilot landing in the wrong direction.Jan 6, 1999 · N50BA · Substantial damageNTSB NYC99LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Methuen, MAThe pilot's failure to ensure the engine primer was in and locked prior to takeoff which resulted in a loss of engine power. A factor in this accident was the pilot's lack of experience in airplanes equipped with reciprocating engines.Jan 5, 1999 · N9683C · Substantial damageNTSB MIA99LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pahokee, FLThe pilot-in command's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command.Jan 5, 1999 · N9225N · Substantial damageNTSB LAX99IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Phoenix, AZThe failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…Jan 5, 1999 · N804MA · Minor damageNTSB IAD99LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Fairfield, VAThe owner's failure to comply with the Airworthiness Directive and the subsequent fuel system filter blockage by ice leading to fuel starvation and power loss of the right engine. Additionally, the pilot's improper selection of the left auxiliary fuel tank…Jan 5, 1999 · N3TH · DestroyedNTSB FTW99LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe student pilot's failure to compensate for a crosswind resulting in a loss of control. Factors were the gusty high winds and the flight instructor's improper decision to allow the student to solo during high winds.Jan 5, 1999 · N80253 · Substantial damageNTSB CHI99LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIthe pilot-in-command's loss of directional control during landing roll. Factors to the accident were the icy terrain condition, crosswind, and the snow bank.Jan 5, 1999 · N53637 · Substantial damageNTSB ANC99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Anchorage, AKThe failure of the driver of a vehicle to maintain an adequate visual lookout.Jan 5, 1999 · N6GR · Substantial damageNTSB LAX99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Barbara, CAA loss of engine power due to an internal left magneto coil primary circuit short. Factors were insufficient altitude and inadequate terrain to make an emergency landing.Jan 4, 1999 · N3585V · Substantial damageNTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.Jan 4, 1999 · N14001 · DestroyedNTSB DEN99TA031Accident · No injuriesFinal reportHughes 369D · Woodruff, UTA partial loss of engine power due to erosion in the compressor assembly module. Factors were a missing rotating labyrinth seal, the installation of which had not been performed by unknown maintenance personnel.Jan 4, 1999 · N5013P · Substantial damageNTSB LAX99TA066Accident · Serious injuriesFinal reportBell 205A-1 · Van Nuys, CAA loss of engine power due to an undetermined component failure in the second stage power turbine nozzle area. Factors in the accident were the mountainous/hilly nature of the terrain and the dark night lighting conditions which precluded the pilot from…Jan 3, 1999 · N58126 · Substantial damageNTSB LAX99LA065Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Delano, CAThe fatigue failure and separation of the oil pump drive from the accessory gear section, which induced an oil starvation failure of the engine. The fatigue failure of the oil pump drive gear was caused by improper machining of the gear's fillet radius during…Jan 3, 1999 · N1079G · Substantial damageNTSB NYC99LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-24R · Farmingdale, NYThe pilot's inadequate preflight examination of the airplane, which resulted in a power loss due to fuel contamination.Jan 2, 1999 · N1857G · Substantial damageNTSB LAX99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hayward, CAThe pilot-in-command's failure to maintain directional control. A factor in this accident was the inadvertent ground loop swerve.Jan 2, 1999 · N4556Z · DestroyedNTSB FTW99FA060Accident · 1 fatalField investigationFinal reportPiper PA-32-300R · Smackover, ARThe pilot's spatial disorientation resulting in a loss of control of the airplane and the ensuing stall/spin. Factors were the low ceilings and the night condition.Jan 2, 1999 · N7676C · DestroyedNTSB ATL99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hogansville, GAFuel exhaustion due to inadequate planning and the pilot's failure to refuel the airplane. Factors were the weather conditions and hilly terrain.Jan 2, 1999 · N5016T · Substantial damageNTSB ATL99LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Colbert, GAInadequate planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jan 2, 1999 · N7295P · Substantial damageNTSB LAX99LA070Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 Broussard · Minden, NVThe pilot's failure to maintain proper runway alignment during a rejected takeoff. A factor in the accident was the undetermined pitch control/trim system problem, which led to the pilot's rejected takeoff decision and may have distracted him during attempts…Jan 1, 1999 · N4022 · Substantial damageNTSB FTW99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Shelbyville, TXThe total failure of the aircraft's electrical system. Factors were the thunderstorms, the dusk light condition, and the lack of suitable terrain for the precautionary landing.Jan 1, 1999 · N234CG · Substantial damageNTSB FTW99LA057Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Marietta, OKThe failure of the pilot-in-command to maintain clearance with terrain. Factors were the short runway and the dark night light condition.Jan 1, 1999 · N30246 · Substantial damageNTSB MIA99LA061Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Lauderdale, FLThe intentional operation of the airplane by the pilot with known deficiencies in equipment (fuel leakage from the carburetor), poor preflight by the pilot for his failure to visually determine that the fuel tanks were full before the initial flight. Factors…Dec 31, 1998 · N29451 · Substantial damageNTSB LAX99LA063Accident · Serious injuriesLimited investigationFinal reportRichard Young Harmon Rocket II · Esparto, CAThe owner's inadequate condition (annual) inspection, which failed to detect a loose fuel pump output line attachment fitting, which resulted in an in-flight fire. A factor in the hard landing and ground loop was the pilot's inability to see through the smoke…Dec 31, 1998 · N288M · DestroyedNTSB LAX99LA062Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Furnace Creek, CAThe pilot's inadequate preflight inspection when he failed to remove the gust lock from the flight controls.Dec 31, 1998 · N2313L · Substantial damageNTSB FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.Dec 31, 1998 · N46285 · Substantial damage