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 LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.Jun 13, 1992 · N8014L · Substantial damageNTSB FTW92GA160Accident · No injuriesFinal reportMcdonnell Douglas 369E · Yukon, OKThe dual student's failure to maintain adequate main rotor RPM and failure to level the helicopter at touchdown. Factors were the manufacturer's training pilot's inadequate supervision and the dual student performing the maneuver.Jun 13, 1992 · N684F · Substantial damageNTSB FTW92GA157Accident · 1 fatalFinal reportHughes OH-6A · Sunland Park, NMThe pilot's failure to see and avoid the wires.Jun 13, 1992 · N10436 · DestroyedNTSB FTW92DQA02Accident · Serious injuriesFinal reportFantasy Sky Promotions AX-7 · Rio Rancho, NMThe pilot's improper inspection of the balloon following removal of two of the fuel tanks which resulted in vented fuel due to a fuel line being left loose and a fuel valve locked open.Jun 13, 1992 · N5355M · Minor damageNTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.Jun 13, 1992 · N9823X · Substantial damageNTSB CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.Jun 13, 1992 · N9534D · Substantial damageNTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.Jun 13, 1992 · N8303Q · Substantial damageNTSB CHI92LA175Accident · 1 fatalLimited investigationFinal reportChampion 7GCAA · Brainerd, MNAn excessive pull up and failure to maintain an airspeed above stalling speed by the pilot in command.Jun 13, 1992 · N2519F · DestroyedNTSB CHI92LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Ladysmith, WIFailure of the pilot to attain a proper touchdown point and the attempted abort of the precautionary landing attempt.Jun 13, 1992 · N52142 · DestroyedNTSB CHI92DTG02Accident · Minor injuriesFinal reportCallair A9B · Bisbee, NDThe loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.Jun 13, 1992 · N7761V · Substantial damageNTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.Jun 13, 1992 · N4PV · DestroyedNTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.Jun 13, 1992 · N2106E · Substantial damageNTSB NYC92LA116Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Greenville, METhe pilots decision to initiate a step turn into the wind. Factors related to the accident were the crosswind and gusts.Jun 12, 1992 · N2816K · Substantial damageNTSB LAX92LA243Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZThe pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.Jun 12, 1992 · N6972G · Substantial damageNTSB CHI92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Liberty, MOThe pilot-in-commands failure to maintain aircraft control. Related factors are the pilot's lack of total experience and improper recovery from a bounced landing.Jun 12, 1992 · N5533A · Substantial damageNTSB CHI92FA170Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Sheboygan Falls, WIThe copilot's premature liftoff and the captain's inadequate remedial action resulting in loss of aircraft control at low altitude.Jun 12, 1992 · N38DJ · DestroyedNTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.Jun 11, 1992 · N8938H · Substantial damageNTSB MIA92LA136Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Live Oak, FLImproper planning/decision by the pilot, and his improper use of the mixture control, which resulted in his failure to attain sufficient altitude to clear trees near the departure end of the runway. The proximity of trees was a related factor.Jun 11, 1992 · N3413T · Substantial damageNTSB LAX92TL#09Accident · No injuriesClass 3Final reportCessna 421C · Window Rock, AZJun 11, 1992 · N6115C · Substantial damageNTSB LAX92FA242Accident · 3 fatalField investigationFinal reportCessna 172I · Chino Hills, CAThe pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.Jun 11, 1992 · N225EB · DestroyedNTSB DEN92LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Englewood, COAirplane climb capability exceeded and an inadvertent pilot induced stall. Factors were: weight and balance exceeded, high density altitude, and improper use of the mixture control.Jun 11, 1992 · N65513 · DestroyedNTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.Jun 11, 1992 · N21906 · Substantial damageNTSB CHI92FA169Accident · 1 fatalField investigationFinal reportMooney M20J · Bloomington, ILThe pilot's failure to maintain aircraft control during the turn from base leg to final approach.Jun 11, 1992 · N302FW · DestroyedNTSB SEA92LA124Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Klamath Falls, ORThe pilot's poor inflight planning/decision. Factors to the accident were: clearance was not maintained and inadequate remedial action.Jun 10, 1992 · N3627S · DestroyedNTSB NYC92LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Woodbine, MDThe student pilot's failure to maintain directional control of the glider during takeoff, which resulted in a ground loop. Factors related to the accident were the student's lack of total flight experience, the instructor's lack of flight experience in this…Jun 10, 1992 · N693RF · Substantial damageNTSB NYC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Denton, MDThe failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.Jun 10, 1992 · N4552X · Substantial damageNTSB NYC92LA106Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2 · Danbury, CTImproper recovery from a bounced landing by the pilot which resulted in a propeller strike which made further flight not possible.Jun 10, 1992 · N155JL · Substantial damageNTSB LAX92TL#08Accident · No injuriesClass 3Final reportPiper PA36-300 · Madera, CAJun 10, 1992 · N2420V · DestroyedNTSB FTW92IA158Incident · No injuriesIncident investigationFinal reportPiper PA-31T · Addison, TXThe failure of the pilot-in-command of the PA-38, N2603B, to follow ATC instructions.Jun 10, 1992 · N182TC · 2 aircraft · No damageNTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.Jun 10, 1992 · N80490 · Substantial damageNTSB CHI92LA166Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOThe flight instructor's delay in initiating a go-around and improper recovery from the student's bounced landing. Factor(s) which contributed to the accident was the student pilot overshooting the approach.Jun 10, 1992 · N152AJ · DestroyedNTSB ATL92LA120Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG 300 · Arabi, GAThe pilot's inadequate visual lookout when he failed to see and avoid obstacles. Factors were the loss of thermal lift and the pilot's diverted attention.Jun 10, 1992 · N433TT · Substantial damageNTSB ANC92LA090Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-500D · Polk Inlet, AKThe pilot's failure to follow proper procedure and the company's inadequate procedures and directives. A factor was the uneven terrain.Jun 10, 1992 · N8395F · Substantial damageNTSB ANC92LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKInadequate visual look out by the pilot of both aircraft. Contributing to the accident were the pilot's diverted attention, the other moving aircraft/object (c 172), and the excessive taxi speed of the c 172.Jun 10, 1992 · N61670 · 2 aircraft · Minor damageNTSB ANC92LA088Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elephant Lake, AKThe dual student's inadequate compensation for wind conditions and the instructor's inadequate supervision. A factor was the tailwind.Jun 10, 1992 · N101TH · Substantial damageNTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.Jun 9, 1992 · N6138S · Substantial damageNTSB SEA92LA122Accident · No injuriesLimited investigationFinal reportNorth American Navion · Spokane, WAThe partial failure of the nose gear trunnion. Factors include the pilot's decision to land with the gear in the up position.Jun 9, 1992 · N91132 · Substantial damageNTSB NYC92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Buffalo, NYThe pilot's failure to maintain airspeed during a go around, which resulted in an inadvertent stall and in flight collision with terrain. Contributing to the accident was the pilot delayed the go around and lack of recent flight expereince.Jun 9, 1992 · N9263H · Substantial damageNTSB NYC92LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Dexter, MEA failure of the top torque link bolt on the nose landing gear which resulted in a landing with a flat strut and misaligned wheel.Jun 9, 1992 · N19801 · Substantial damageNTSB NYC92FA103Accident · 1 fatalField investigationFinal reportCessna 180G · Reynoldsville, PAThe pilot's failure to refuel resulting in fuel exhaustion and subsequent forced landing in trees.Jun 9, 1992 · N4731U · Substantial damageNTSB MIA92LA135Accident · Minor injuriesLimited investigationFinal reportHiller UH12C · Punta Gorda, FLThe pilot in command's failure to monitor fuel consumption and flight time resulting in exhaustion of fuel and engine failure. Contributing to the accident was the pilot in command's improper autorotation following engine failure which resulted in a hard…Jun 9, 1992 · N46937 · Substantial damageNTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.Jun 9, 1992 · N5123Q · Substantial damageNTSB MIA92GA134Accident · 1 fatalFinal reportCessna U206-F · Live Oak, FLImproper maintenance of the fuel system by the pilot/mechanic resulting in an engine failure on takeoff over terrain unsuitable for a forced landing. Contributing to the accident was the pilot's improper in-flight decision to turn back to the runway, and…Jun 9, 1992 · N8117Q · Substantial damageNTSB LAX92LA239Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chino, CAThe loss of engine power for undetermined reasons. The pilot's misjuding the flare was a factor.Jun 9, 1992 · N31961 · Substantial damageNTSB LAX92FA241Accident · 3 fatalField investigationFinal reportCessna 172P · Big Sur, CAPilot incapacition.Jun 9, 1992 · N5449K · DestroyedNTSB CHI92LA167Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wyatt, MOAn improper decision during flight when the pilot in command overflew two suitable landing areas after a partial power loss in one engine. The mechanical deficiencies in the engines were factors in the engine.Jun 9, 1992 · N1050X · Substantial damageNTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.Jun 9, 1992 · N2776N · Substantial damageNTSB NYC92LA102Accident · No injuriesLimited investigationFinal reportGrumman 164A · Bridgeton, NJThe pilot's improper application of takeoff power which resulted in a lengthened takeoff roll, and his subsequent steep turn to avoid an obstacle causing the airplane to stall at a low altitude.Jun 8, 1992 · N48399 · Substantial damageNTSB MIA92LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Opa Locka, FLThe pilot's inadequate compensation for wind condition and failure to maintain runway alignment during the landing roll. A contributing factor was a shifting crosswind.Jun 8, 1992 · N9307P · Substantial damageNTSB FTW92LA154Accident · No injuriesLimited investigationFinal reportBeech 76 · Sherman, TXThe instructor pilot's delayed remedial action, improper configuration, and inadvertent stall.Jun 8, 1992 · N6003V · Substantial damage