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 SEA96LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORfailure of the pilot to properly judge the distance and altitude to the runway just before touching down, and his premature flare for landing. Factors relating to the accident were: the presence of sun glare during the landing, and the resultant degradation…May 27, 1996 · N177JM · Substantial damageNTSB SEA96LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12 · Walla Walla, WAthe pilot's inadequate preflight/planning, and his failure to refuel the helicopter with sufficient fuel before flight, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: an inaccurate fuel quantity…May 27, 1996 · N174HA · Substantial damageNTSB FTW96LA227Accident · No injuriesLimited investigationFinal reportCessna 414 · Broomfield, COfailure of the pilot to maintain adequate visual lookout by allowing his attention to be diverted.May 27, 1996 · N414AW · Substantial damageNTSB CHI96IA173Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146 · Des Moines, IAfailure of the flight crew to follow proper procedures, which resulted in an accumulation of ice and subsequent loss of engine power. Factors relating to the incident were: thunderstorms, turbulence, icing conditions, and the inaccurate method that was…May 27, 1996 · N608AW · No damageNTSB SEA96LA099Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDthe pilot's failure to properly judge the distance and speed of the airplane during the final approach, his failure to obtain a proper touchdown point for landing, and his failure to perform a go-around, while there was sufficient runway remaining. A factor…May 26, 1996 · N626RP · Substantial damageNTSB SEA96LA098Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Brookings, ORthe pilot's misjudgment of distance/speed during the approach to landing, his failure to attain a proper touchdown point for landing, and his failure to perform a go-around, while there was sufficient runway and airspeed remaining. The tailwind was a related…May 26, 1996 · N56642 · Substantial damageNTSB LAX96LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Los Banos, CAfuel exhaustion due to the pilot's improper in-flight decision to utilize a high engine power setting which reduced the airplane's endurance, and the pilot's inadequate fuel consumption calculations.May 26, 1996 · N66392 · Substantial damageNTSB FTW96LA229Accident · No injuriesLimited investigationFinal reportBell 47J · Lakeway, TXThe pilot's failure to maintain a proper descent rate prior to landing.May 26, 1996 · N8412E · Substantial damageNTSB CHI96LA187Accident · No injuriesLimited investigationFinal reportCessna P206 · Goshen, INthe parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.May 26, 1996 · N2625X · Substantial damageNTSB CHI96FA172Accident · 2 fatalField investigationFinal reportCessna 152 · Mount Pleasant, MIloss of aircraft control by the pilot, due to cardiac arrest (heart attack).May 26, 1996 · N68610 · DestroyedNTSB ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.May 26, 1996 · N7030G · Substantial damageNTSB SEA96LA097Accident · No injuriesLimited investigationFinal reportPowers Bede BD-4 · Pacific City, ORthe pilot's inadequate compensation for wind conditions during the landing flare, and his failure to maintain runway alignment, which resulted in an encounter with tall grass beside the intended landing area. Factors relating to the accident were: the…May 25, 1996 · N239CP · Substantial damageNTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.May 25, 1996 · N10439 · Substantial damageNTSB NYC96LA114Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · East Canton, PAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control and subsequent collision with obstacles. The gusty crosswind condition was a related factor.May 25, 1996 · N32091 · Substantial damageNTSB LAX96LA218Accident · No injuriesLimited investigationFinal reportSchweizer 1-24 · Tehachapi, CAthe glider pilot's decision to land on the grass covered infield instead of the alternate runway, and the pilot's failure to maintain directional control. Contributing to the accident was the pilot's improper use of the spoilers and brakes.May 25, 1996 · N91888 · Substantial damageNTSB LAX96LA204Accident · 1 fatalLimited investigationFinal reportGrumman G-164 · Colusa, CAfailure of the pilot to remain clear of the power lines. Factors relating to the accident were: Lack of visual cues at dawn, and the power lines.May 25, 1996 · N48379 · DestroyedNTSB LAX96FA206Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Los Angeles, CAthe crew's failure to maintain the proper approach airspeed and rate of descent. Contributing to the accident was the crew's failure to follow the checklist and inadequate supervision by the pilot-in-command.May 25, 1996 · HL737 · Substantial damageNTSB IAD96LA086Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Stevensville, MDThe pilot's misjudgment of the amount of fuel he had onboard the airplane which resulted in an engine failure due to fuel exhaustion. Contributing to the severity of the accident was the high vegetation encountered during the forced landing which resulted in…May 25, 1996 · N456JE · Substantial damageNTSB CHI96LA186Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Crookston, MNcatastrophic engine failure.May 25, 1996 · N48518 · Substantial damageNTSB CHI96LA178Accident · Minor injuriesLimited investigationFinal reportDickinson Fisher Classic · Mooresville, INthe pilot failed to maintain adequate altitude and clearance from the trees, and had made an improper in-flight decision when he got to far from a suitable landing area. The reason for the loss of power failure was undetermined.May 25, 1996 · N6292B · Substantial damageNTSB CHI96LA176Accident · No injuriesLimited investigationFinal reportMerlin GT · Charlotte, MIthe pilot's failure to maintain airspeed. A factor was the pilot's lack of experience in the airplane.May 25, 1996 · N68EV · Substantial damageNTSB CHI96LA174Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Osage Beach, MOa partial loss of power for undetermined reasons.May 25, 1996 · N40933 · Substantial damageNTSB ANC96FA079Accident · 2 fatalField investigationFinal reportRepublic RC-3 Seabee · Ketchikan, AKthe airplane crashed for undetermined reason(s).May 25, 1996 · N99FJ · DestroyedNTSB NYC96LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Macedon, NYa blocked gascolator, inadequate maintenance, and the pilot's decision to fly with a known fuel flow deficiency, which resulted in a loss of engine power, forced landing, and subsequent nose over.May 24, 1996 · N2189B · Substantial damageNTSB NYC96FA113Accident · No injuriesField investigationFinal reportBeech A36 · Meriden, CTthe pilot's improper planning/decision, his failure to use takeoff power, and his premature lift-off of the airplane, which resulted in an inadvertent stall/mush and subsequent collision with terrain. Factors relating to the accident were: the pilot allowing…May 24, 1996 · N59WW · DestroyedNTSB MIA96LA149Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Orlando, FLloss of power in both engines for undetermined reason(s).May 24, 1996 · N441CB · Substantial damageNTSB LAX96LA211Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Fallbrook, CAfailure of the pilot to attain the proper touchdown point on the runway, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the excessive airspeed on final approach, and the short and wet condition of the…May 24, 1996 · N23MB · Substantial damageNTSB IAD96FA085Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Stevensville, MDThe pilot's improper short field takeoff/procedure and selection of the wrong runway for takeoff.May 24, 1996 · N103RW · DestroyedNTSB FTW96LA226Accident · Serious injuriesLimited investigationFinal reportNavion NA1 · Los Lunas, NMThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 24, 1996 · N2530T · Substantial damageNTSB CHI96IA170Incident · No injuriesIncident investigationFinal reportBeech 1900D · Indianapolis, INfailure of a forward cabin ventilation blower motor bearing, which resulted in binding of the blower motor; and inadequate design of the electrical system, which allowed overheating of the electrical circuit and smoke in the cabin of the aircraft.May 24, 1996 · N148SK · Minor damageNTSB ANC96LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kivalina, AKThe pilot's selection of an unsuitable takeoff area.May 24, 1996 · N83616 · Substantial damageNTSB ANC96FA078Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Point Hope, AKThe pilot's inadequate preflight to ensure the nose baggage door was properly latched, and the subsequent opening of the baggage compartment door, which allowed items to collide with the left propeller, resulting in propeller damage and loss of thrust from…May 24, 1996 · N4109E · Substantial damageNTSB FTW96LA225Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXthe pilot's improper preflight by failing to ensure the mixture control was properly set before takeoff, and his failure to abort the takeoff (while there was sufficient runway remaining).May 23, 1996 · N52MA · DestroyedNTSB CHI96FA169Accident · 1 fatalField investigationFinal reportBeech F33A · Saint Clair, MOfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in a stall and collision with the terrain.May 23, 1996 · N8273G · DestroyedNTSB LAX96LA210Accident · No injuriesLimited investigationFinal reportRotorway Exec 9 · Chandler, AZa loss of engine power due to a failed piston and piston ring in a critical phase of flight.May 22, 1996 · N89678 · Substantial damageNTSB IAD96LA082Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Clinton, MDthe pilot's failure to assure that an adequate supply of fuel was available for the flight. Related factors were the pilot's inadequate airplane preflight inspection and the unsuitable terrain (horses, fence, house, barn, trees) encountered during the landing…May 22, 1996 · N2594B · Substantial damageNTSB FTW96LA224Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Lunas, NMloss of total engine power due to fuel exhaustion for undetermined reason(s). The lack of suitable terrain for the forced landing was a related factor. The worn and leaking fuel system components and inadequate maintenance by unknown personnel were possible…May 22, 1996 · N1813H · Substantial damageNTSB NYC96LA112Accident · No injuriesLimited investigationFinal reportAeronca 7EC · New Castle, PAthe pilot's failure to maintain directional control during the landing roll, which resulted in a ground swerve and an encounter with high grass and a ditch off the side of the runway.May 21, 1996 · N1536E · Substantial damageNTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.May 21, 1996 · N2062J · Substantial damageNTSB ANC96LA076Accident · Minor injuriesLimited investigationFinal reportBeech 99C · Barrow, AKan in-flight collision with a bird.May 21, 1996 · N216CS · Substantial damageNTSB SEA96LA096Accident · No injuriesLimited investigationFinal reportTilbert Baby Great Lakes · Stevensville, MTthe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in loss of directional control and an inadvertent ground swerve. Factors relating to the accident were: the adverse wind conditions (crosswind and gusts),…May 20, 1996 · N94AT · Substantial damageNTSB NYC96LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Monticello, NYthe student pilot's inadequate compensation for wind conditions, and her delay in aborting the landing. The gusty crosswind condition was a related factor.May 20, 1996 · N38890 · DestroyedNTSB MIA96LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Vilarica, GAThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's improper use of flaps.May 20, 1996 · N2814U · Substantial damageNTSB MIA96LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) while maneuvering during a go-around, resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's failure to achieve the proper touchdown point…May 20, 1996 · N9164B · Substantial damageNTSB IAD96LA079Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carrollton, OHThe pilot's inadequate fuel management. Factors in this accident were the pilot's reliance on a fuel data computer and his untimely reaction to a known fuel quantity discrepancy.May 20, 1996 · N731NC · Substantial damageNTSB FTW96LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Paradise, TXThe loss of engine power and hydraulic pressure for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.May 20, 1996 · N299MD · Substantial damageNTSB CHI96LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Letcher, SDthe pilot's inadequate evaluation of the severe weather condition. A factor was the weather conditions.May 20, 1996 · N1019X · Substantial damageNTSB CHI96FA171Accident · No injuriesField investigationFinal reportCessna 401 · Great Bend, KSthe failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.May 20, 1996 · N701CJ · Substantial damageNTSB ANC96TA075Accident · No injuriesFinal reportCessna A-185-F · Juneau, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the crosswind.May 20, 1996 · N56581 · Substantial damageNTSB SEA96LA095Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cut Bank, MTthe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. Factors relating to the accident were: the unfavorable wind conditions (crosswind and…May 19, 1996 · N9808K · Substantial damage