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 LAX95LA221Accident · No injuriesLimited investigationFinal reportCessna 172 · Yerington, NVThe pilot's improper in-flight decision to enter mountainous terrain at an insufficient altitude to safely escape adverse weather conditions. Factors relating to the accident were: the terrain and weather conditions.Jun 23, 1995 · N5363T · Substantial damageNTSB FTW95LA258Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Kingston, OKA malfunction of the propeller governor due to a loose control cable.Jun 23, 1995 · N5273C · Substantial damageNTSB FTW95LA257Accident · 1 fatalLimited investigationFinal reportRocky Mountain Buccaneer 11 B2B · Longmont, COThe pilot's failure to maintain flying speed, resulting in an inadvertent stall while attempting to make a forced landing. Factors were the pilot's lack of total experience in airplane make/model, improper maintenance of the airplane, and operation of the…Jun 23, 1995 · N4093F · DestroyedNTSB CHI95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Columbia, MOA loose (or missing) nut and clip for the bottom magneto stud, due to inadequate maintenance, and fatigue failure of the magneto housing flange, which restulted in an oil leak, engine compartment fire, and a forced landing. A factor relating to the accident…Jun 23, 1995 · N39620 · Substantial damageNTSB CHI95LA194Accident · No injuriesLimited investigationFinal reportPiper J-5A · Wausau, WIthe pilot's misjudgment of the clearance between the airplane and the fuel pumps.Jun 23, 1995 · N40888 · Substantial damageNTSB BFO95LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Wauseon, OHThe pilot's failure to obtain/maintain adequate altitude/clearance from obstacles during an attempted go-round. Related factors are the pilot's failure to attain the planned approach and the improper go-around procedures.Jun 23, 1995 · N6403B · DestroyedNTSB BFO95LA073Accident · Minor injuriesLimited investigationFinal reportKemp ACRO-SPORT II · Honeoye Falls, NYthe pilot's inadequate preflight planning/preparation and his misjudging of the touchdown during the forced landing. Related factors are the pilot's improper maintenance, and fuel contamination.Jun 23, 1995 · N27727 · DestroyedNTSB ANC95LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Minto, AKThe pilot's failure to abort the takeoff in a timely manner. A factor relating to the accident was: the pilot's failure to use all of the available area (waterway) for the takeoff.Jun 23, 1995 · N5177E · Substantial damageNTSB SEA95LA124Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Renton, WAThe pilot misjudged the flare.Jun 22, 1995 · N709JV · Substantial damageNTSB MIA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Opa-Locka, FLThe failure of maintenance personnel to comply with manufacturer inspection procedures for hydraulic lines resulting in the failure of the right main gear door line and loss of all hydraulic fluid.Jun 22, 1995 · N530JB · Substantial damageNTSB LAX95LA220Accident · No injuriesLimited investigationFinal reportCessna 310 · Henderson, NVa brake system malfunction for undetermined reasons.Jun 22, 1995 · N5302A · Substantial damageNTSB CHI95LA195Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNThe pilot's improper inflight planning/decision, which resulted in continued flight into adverse weather. Factors relating to the accident were: the thunderstorm outflow, and inadequate weather evaluation by the pilot.Jun 22, 1995 · N2027E · Substantial damageNTSB ANC95LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's inadvertent stall of the airplane.Jun 22, 1995 · N82022 · Substantial damageNTSB SEA95FA137Accident · 2 fatalField investigationFinal reportBeech A36 · Brinnon, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the terrain. Factors in the accident were the mountains and the clouds.Jun 21, 1995 · N20239 · DestroyedNTSB LAX95GA219Accident · 3 fatalFinal reportDouglas C-54G · Ramona, CAInadequate visual lookout by the Beech 58P pilot, and the operator's inadequate procedures concerning 360-degree overhead approaches.Jun 21, 1995 · N4989P · 2 aircraft · DestroyedNTSB FTW95LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe loss of engine power as result of the failure of the number two cylinder. Factors were the unsuitable terrain available for the forced landing and the pilot's restricted vision due to oil on the windshield.Jun 21, 1995 · N4537L · DestroyedNTSB FTW95LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Craig, COThe pilot became lost and disoriented, resulting in fuel exhaustion. Factors were the lack of suitable terrain for a forced landing and the operation of the aircraft with known deficiencies in equipment.Jun 21, 1995 · N45936 · Substantial damageNTSB CHI95LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Bovey, MNThe pilot's delay in aborting the takeoff.Jun 21, 1995 · N45200 · Substantial damageNTSB CHI95IA189Incident · No injuriesIncident investigationFinal reportBell 222UT · Des Moines, IAdelamination of the left engine air inlet duct.Jun 21, 1995 · N274SM · Minor damageNTSB CHI95FA191Accident · 1 fatalField investigationFinal reportChampion 8KCAB · Frankfort, ILthe pilot-in-command's overconfidence in his personal ability in attempting to teach aerobatics, his lack of experience as a flight instructor, and allowing the airplane to get into a position where its never exceed speed and design stress limits were…Jun 21, 1995 · N109AC · DestroyedNTSB BFO95LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Utica, NYThe pilot's improper retraction of the flaps.Jun 21, 1995 · N2423A · Substantial damageNTSB ATL95LA116Accident · 1 fatalLimited investigationFinal reportSmith Monnett Moni · Cheraw, SCThe loss of engine power for unknown reasons, and the pilot's failure to maintain flying speed, which resulted in impact with the ground while the airplane was in a stalled condition.Jun 21, 1995 · N3257W · Substantial damageNTSB ANC95FA078Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe failure of both pilots to maintain adequate visual lookout.Jun 21, 1995 · N1348 · 2 aircraft · DestroyedNTSB LAX95LA218Accident · Minor injuriesLimited investigationFinal reportED Bergreen KIS · San Leandro, CAthe pilot's poor preflight preparation and in-flight decision to overfly a suitable airport when it was evident that he was having an engine problem. The fuel exhaustion was a factor in this accident.Jun 20, 1995 · N62TW · Substantial damageNTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.Jun 20, 1995 · N7937 · Substantial damageNTSB CHI95LA188Accident · Serious injuriesLimited investigationFinal reportBoeing 767-222 · Champagne, ILan in-flight encounter with turbulence.Jun 20, 1995 · N606UA · No damageNTSB BFO95LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Factoryville, PAthe loss of engine power for undetermined reasons, and the subsequent hard landing by the student pilot.Jun 20, 1995 · N4876F · Substantial damageNTSB BFO95LA068Accident · No injuriesLimited investigationFinal reportCessna 180H · Chatsworth, NJthe pilot's failure to maintain directional control during the takeoff roll. Related factors were the gusty crosswind conditions.Jun 20, 1995 · N2728X · Substantial damageNTSB ATL95LA115Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Livingston, ALThe loss of engine power for undetermined reasons.Jun 20, 1995 · N101VB · Substantial damageNTSB MIA95WA171Accident · No injuriesForeign investigationWillingham, Dave L. Kolb Twinstar · Freeport, BahamasJun 19, 1995 · N5759 · Substantial damageNTSB LAX95FA217Accident · 1 fatalField investigationFinal reportCessna 172N · Vidal Junction, CAThe pilot's failure to maintain an altitude adequate to avoid the mountainous/hilly terrain. Contributing to the accident was the glare from the setting sun.Jun 19, 1995 · N739KJ · DestroyedNTSB FTW95LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Weslaco, TXThe inadequate visual lookout by both pilots. A factor was the inability of the pilots to communicate by radio due to the incompatible equipment installed in the two airplanes.Jun 19, 1995 · N53372 · 2 aircraft · Substantial damageNTSB FTW95LA251Accident · Serious injuriesLimited investigationFinal reportStewart Pitts S-1S · Cleburne, TXThe pilot's misjudged flare and the ensuing hard landing. Factors were the pilot's improper fuel consumption calculations and the fuel exhaustion.Jun 19, 1995 · N901S · Substantial damageNTSB CHI95LA187Accident · No injuriesLimited investigationFinal reportBell 47J2A · Elkhorn, WIloss of power as a result of an intake valve failure due to improper maintenance performed during the major engine overhaul, and pilot misjudgment of the flare during autorotation.Jun 19, 1995 · N470RA · Substantial damageNTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.Jun 19, 1995 · N91469 · DestroyedNTSB SEA95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Laurel, MTThe selection of unsuitable terrain for landing. A factor to the accident was tall vegetation.Jun 18, 1995 · N1252C · Substantial damageNTSB SEA95LA121Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Helena, MTThe pilots failure to maintain directional control. Contributing to the accident was the crosswind.Jun 18, 1995 · N1967M · Substantial damageNTSB NYC95LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yellow Springs, OHinadequate visual lookout by the pilot which resulted in the airplane striking the tower.Jun 18, 1995 · N7239H · Substantial damageNTSB MIA95LA151Accident · No injuriesLimited investigationFinal reportBeech C24R · Houston, MSPartial loss of engine power due to a fuel injector being clogged with carbon. This resulted in a landing on unsuitable terrain.Jun 18, 1995 · N24024 · Substantial damageNTSB LAX95LA239Accident · No injuriesLimited investigationFinal reportCessna 182A · Paso Robles, CAFailure of the great lakes pilot to see-and-avoid the Cessna 182. The sun glare was a related factor.Jun 18, 1995 · N4824D · 2 aircraft · Substantial damageNTSB LAX95LA216Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Coalinga, CAclutch slippage for undetermined reasons. A factor in the accident was the helicopter's low above ground altitude, which limited the pilot's time and ability to recover main rotor rpm.Jun 18, 1995 · N7923J · DestroyedNTSB LAX95LA215Accident · Serious injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Dayton, NVthe pilot's delayed decision to extend and use the engine to maintain adequate terrain clearance after encountering downdrafts.Jun 18, 1995 · N30PK · Substantial damageNTSB LAX95LA214Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Nipomo, CAthe pilot's improper handling of the helicopter by her failure to maintain an adequate airspeed for the attempted maneuver resulting in an uncontrolled descent and subsequent collision with the ground.Jun 18, 1995 · N115B · DestroyedNTSB LAX95LA213Accident · No injuriesLimited investigationFinal reportBell 47-G2A · Bakersfield, CAthe pilot's failure to maintain adequate lateral clearance from the irrigation standpipe while applying chemicals to a field.Jun 18, 1995 · N73260 · Substantial damageNTSB LAX95LA212Accident · No injuriesLimited investigationFinal reportTupta-Smith Miniplane DSA-1 · Pacoima, CAfuel contamination.Jun 18, 1995 · N8510 · Substantial damageNTSB FTW95LA250Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXThe pilot's failure to attain runway alignment. Factors were the pilot's failure to perform a go-around and his lack of total experience in the make and model of airplane.Jun 18, 1995 · N6542F · Substantial damageNTSB CHI95LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brooklyn, MIthe pilot operating the airplane with a known deficiency. A factor was the pilot not maintaining control of the airplane.Jun 18, 1995 · N5195L · DestroyedNTSB BFO95LA066Accident · 1 fatalLimited investigationFinal reportDrake Moni · Pittsfield, MAthe pilot's failure to maintain/regain control of the aircraft during the simulated engine-out procedure while on approach to landing.Jun 18, 1995 · N787DD · DestroyedNTSB BFO95LA065Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Grand River, OHThe pilot selected unsuitable terrain for the takeoff.Jun 18, 1995 · N33719 · Substantial damageNTSB SEA95FA120Accident · 1 fatalField investigationFinal reportCessna 175A · Moab, UTThe pilot's failure to maintain proper altitude in the visual flight rules (VFR) traffic pattern. Contributing to the accident were the pilot's failure to follow dispatch procedures, the dark night conditions, and the unavailability of the airport's…Jun 17, 1995 · N6970E · Destroyed