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 FTW99LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Wharton, TXThe pilot's failure to comply with the manufacturer's single engine landing checklist which resulted in the aircraft landing short of the runway.Jan 28, 1999 · N8729E · Substantial damageNTSB DCA99WA035Accident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Naples, ItalyJan 28, 1999 · IDAVN · Substantial damageNTSB ATL99FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Brevard, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.Jan 28, 1999 · N1875H · DestroyedNTSB NYC99LA053Accident · Serious injuriesLimited investigationFinal reportGrove AIR Command · Centre Hall, PAThe pilot's failure to maintain clearance from a power line. A factor was the sunglare.Jan 27, 1999 · N52910 · Substantial damageNTSB CHI99LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Hyannis, NEthe pilot's failure to maintain clearance with the transmission line. Factors associated with the accident were the transmission line, the low altitude at which the pilot was flying, and his diverted attention to a person on the ground.Jan 27, 1999 · N7188Z · Substantial damageNTSB MIA99LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Charleston, SCthe total loss of engine power caused by an oil leak at the oil filter adapter, resulting in a broken connecting rod, a subsequent forced landing and impact with rough terrain.Jan 26, 1999 · N4976M · Substantial damageNTSB LAX99LA082Accident · No injuriesLimited investigationFinal reportCessna 172L · Santa Paula, CAThe instructor pilot's misjudged altitude and speed, which resulted in a failure to attain the proper touchdown point causing an overrun and collision with a block wall. A factor was the wet runway, which may have hindered brake effectiveness.Jan 26, 1999 · N7639G · Substantial damageNTSB FTW99LA071Accident · No injuriesLimited investigationFinal reportCessna 172E · Guymon, OKThe pilot's failure to maintain aircraft control. A factor was the gusty crosswind.Jan 26, 1999 · N5606T · Substantial damageNTSB MIA99LA068Accident · No injuriesLimited investigationFinal reportCessna 310N · Clearwater, FLa ground fire in the left wing due to an undetermined ignition source.Jan 25, 1999 · N5080Q · Substantial damageNTSB FTW99LA069Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Nemo, TXA partial loss of engine power due to the obstructed fuel vent line and fuel cap vent.Jan 25, 1999 · N152PA · Substantial damageNTSB CHI99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elmo, MNthe student pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the snow covered, icy runway condition and the snowbank which the airplane contacted.Jan 25, 1999 · N752AA · Substantial damageNTSB CHI99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Rockford, ILthe failure of the pilot to maintain flying speed and ground clearance while on a night circling approach. Factors were existing icing conditions and the airframe and windshield icing.Jan 25, 1999 · N181JW · Substantial damageNTSB LAX99LA081Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Lemoore, CAThe inadequate nature of the operator's maintenance, which failed to detect the primer and magneto discrepancies. An overly lean fuel mixture and/or magneto cross firing resulted in detonation, an ensuing connecting rod failure, and a total loss of engine…Jan 24, 1999 · N67064 · Substantial damageNTSB LAX99FA080Accident · 2 fatalField investigationFinal reportNorth American T-6G-NA · New River, AZThe pilot's delayed recovery after an intentional stall/spin of 3 to 4 rotations. A factor was the pilot's inadequate entry altitude for the intended maneuver.Jan 23, 1999 · N2757G · DestroyedNTSB FTW99LA070Accident · No injuriesLimited investigationFinal reportCessna 180J · Granbury, TXThe loss of engine power due to an undetermined reason. A factor was the power lines crossing the final approach path.Jan 23, 1999 · N52170 · Substantial damageNTSB NYC99LA052Accident · No injuriesLimited investigationFinal reportBeech 1900D · Hyannis, MAThe captain's improper placement of the power levers in the BETA position, while the airplane was inflight. Factors were the fog and dusk conditions.Jan 22, 1999 · N215CJ · Substantial damageNTSB NYC99LA051Accident · No injuriesLimited investigationFinal reportCessna 650 · Columbus, OHThe collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.Jan 22, 1999 · N782QS · Substantial damageNTSB CHI99FA075Accident · 2 fatalField investigationFinal reportBeech BE-55 · Elkhart, INthe pilot failed to maintain a proper glidepath and obstacle clearance. Factors were the fog and dark night.Jan 22, 1999 · N40HC · DestroyedNTSB CHI99FA072Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Pellston, MIthe pilot's failure to maintain proper altitude/clearance on the approach and his flight into known icing conditions. Factors relating to this accident were the pilot flying with known equipment deficiencies, the pilot's physical impairment (alcohol), the…Jan 22, 1999 · N4920M · DestroyedNTSB MIA99LA066Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW27 · Winter Haven, FLan in-flight collision with wires.Jan 21, 1999 · N387T · Minor damageNTSB LAX99LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe CFI's loss of airplane control upon encountering a dust devil due to his improper in-flight decision to land in proximity to the observed adverse weather conditions.Jan 21, 1999 · N96640 · Substantial damageNTSB FTW99LA068Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Edmond, OKThe pilot's failure to attain the proper touchdown point due to excessive airspeed and his failure to abort the landing. Factors were the pilot's excessive braking and the short, grass runway.Jan 21, 1999 · N19Y · Substantial damageNTSB SEA99IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 747-238B · Pacific Ocean (Pacific Ocean)An encounter with Clear Air Turbulence at Flight Level 330.Jan 20, 1999 · N14024 · Minor damageNTSB LAX99FA078Accident · 1 fatalField investigationFinal reportCessna 182P · Danville, CAThe pilot's disregard for the preflight weather briefing, and his intentional continuation into adverse weather conditions.Jan 20, 1999 · N8579M · DestroyedNTSB DEN99FA034Accident · 3 fatalField investigationFinal reportCessna P210N · Albuquerque, NMTotal failure of the vacuum system, and failure of the pilot to maintain aircraft control, resulting in wing spar failure. Factors were the pilot's spatial disorientation, and his exceeding the design stress limits of the airplane.Jan 20, 1999 · N79NL · DestroyedNTSB CHI99LA071Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOthe instructor pilot's failure to maintain aircraft control. Factors contributing to this accident were the snow covered grassy field area along the side of the runway and the pile of snow.Jan 20, 1999 · N4172P · Substantial damageNTSB CHI99LA069Accident · No injuriesLimited investigationFinal reportCessna 150C · Middleton, WIinadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.Jan 20, 1999 · N1956Z · Substantial damageNTSB SEA99LA031Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Tensed, IDThe pilot-in-command's inadequate fuel management which resulted in fuel exhaustion. Contributing factors were the absence of cautionary markings on the fuel gauge, and high trees at the accident site.Jan 19, 1999 · N67264 · Substantial damageNTSB LAX99FA077Accident · 4 fatalField investigationFinal reportBeech F35 · Chino, CAThe pilot's intentional flight into known instrument meteorological conditions in hilly terrain and his failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's inadequate evaluation of the weather conditions, dark night…Jan 19, 1999 · N3364C · DestroyedNTSB CHI99LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Hillsdale, MIthe pilot's disregarding preparation for the flight. Factors were a frozen landing gear wheel, and the snowbank.Jan 19, 1999 · N8142F · Substantial damageNTSB CHI99LA070Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Schaumburg, ILthe pilot's failure to maintain directional control of the airplane. A factor associated with the accident was the snowbank which the airplane contacted.Jan 19, 1999 · N2197B · Substantial damageNTSB ANC99IA025Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Fairbanks, AKThe improper overhaul of the thrust reverser pneumatic drive unit, and the subsequent failure of the thrust reverser actuator. Factors associated with the incident were the inadequate quality assurance procedures by the overhaul company.Jan 19, 1999 · N481EV · Minor damageNTSB LAX99RA235Incident · No injuriesForeign investigationCessna 550 · Paris, FranceJan 18, 1999 · HBVITNTSB FTW99LA093Accident · No injuriesLimited investigationFinal reportBeech G35 · Ennis, TXFlutter of the empennage for an undetermined reason, which resulted in damage to the aft fuselage.Jan 18, 1999 · N4662D · Substantial damageNTSB DEN99IA033Incident · No injuriesIncident investigationFinal reportBeech E90 · Clovis, NMTotal failure of the elevator control cable due to a short circuit from chafing against an adjoining electrical cable, and failure of maintenance personnel to detect the problem during an AAIP phase inspection.Jan 18, 1999 · N16NM · No damageNTSB LAX99LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Burson, CAThe pilot's failure to maintain adequate airspeed while maneuvering to avoid an obstacle immediately after takeoff. A factor in the accident was the pilot's inadequate examination of the off-airport takeoff area in order to identify potential hazards.Jan 17, 1999 · N89513 · Substantial damageNTSB LAX99LA074Accident · No injuriesLimited investigationFinal reportAbraham J G II/Erickson K ONE Design · No Las Vegas, NVThe separation of the left rudder control cable from the rudder horn due to the improper installation of a nicopress fitting that secured the cable to the control horn.Jan 17, 1999 · N857JA · DestroyedNTSB FTW99FA067Accident · 4 fatalField investigationFinal reportCessna 182B · Honobia, OKThe pilot's failure to maintain aircraft control for an undetermined reason.Jan 17, 1999 · N8433T · DestroyedNTSB DCA99RA033Accident · 4 fatalForeign investigationCessna CE-208 · Jumla, NepalJan 17, 1999 · UNKNTSB CHI99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Charles, ILA loss of engine power due to fuel exhaustion. Also causal was the pilot's inadequate preflight/planning preparation which led to inadvertent flight into instrument meteorological conditions and him becoming lost/disoriented. Contributing to the accident were…Jan 17, 1999 · N40712 · Substantial damageNTSB SEA99LA030Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Moses Lake, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jan 16, 1999 · N9326B · Substantial damageNTSB LAX99LA075Accident · No injuriesLimited investigationFinal reportHanson Hanson Tailwind W-8 · Chula Vista, CAThe loss of lubrication to the number 3 rod bearing and the resulting failure of the number 3 connecting rod. A contributing factor to the accident was the soft terrain at the accident location.Jan 16, 1999 · N8188 · DestroyedNTSB DEN99LA032Accident · No injuriesLimited investigationFinal reportCessna 182M · Longmont, COThe pilot's poor judgment by intentionally buzzing. A factor was an unfavorable wind that caused inadequate altitude/clearance to maneuver and avoid nearby houses.Jan 16, 1999 · N555NP · DestroyedNTSB CHI99LA067Accident · Minor injuriesLimited investigationFinal reportBaker Fisher Horizon · Bolivar, MOThe pilot's improper use of carburetor heat which resulted in carburetor icing and subsequent loss of engine power.Jan 16, 1999 · N793DB · Substantial damageNTSB CHI99LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Creal Springs, ILwas the pilot having the fuel tank selector in the improper position and not following the airplane manufacturer's emergency procedures to restore a loss of power. A factor in this accident was fuel starvation.Jan 16, 1999 · N3689W · DestroyedNTSB NYC99LA050Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9 · Plainfield, PAThe wake turbulence from the proceeding Boeing 747.Jan 15, 1999 · N300ME · No damageNTSB NYC99LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lynchburg, VAFuel exhaustion for undetermined reasons.Jan 15, 1999 · N72EZ · Substantial damageNTSB IAD99LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Fairfield, NJThe flight instructor's failure to maintain rotor rpm and his failure to complete the autorotational descent. A factor in the accident was the flight instructor's failure to fully deploy carburetor heat as directed in the Pilot's Operating Handbook.Jan 15, 1999 · N8041J · Substantial damageNTSB IAD99LA027Accident · No injuriesLimited investigationFinal reportCessna 421B · Youngstown, OHThe pilot's failure to maintain aircraft control. A factor was the icy runway.Jan 15, 1999 · N882BB · Substantial damageNTSB DCA99WA031Accident · No injuriesForeign investigationBoeing 767-300 · London, United KingdomJan 15, 1999 · N373AA · Substantial damage