NTSB investigations, 1996
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 1996 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.
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 WHERE year(c."eventDate") = 1996 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX97WA094Accident · No injuriesForeign investigationCessna 182N · Obergon, MexicoNTSB LAX97FA067Accident · 1 fatalField investigationFinal reportBeech V35B · Lake Tahoe, CAthe pilot's intentional flight into adverse weather and improper in-flight planning and decision making.NTSB LAX97FA066Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Riverside, CAfuel starvation due to improper fuel management. Contributing to the accident was the pilot's preoccupation of discussing the legality of the approach with the tower controller, and fatigue.NTSB IAD97LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Elyria, OHThe pilot's fuel mismanagement which led to fuel starvation to one engine, and the pilot's failure to maintain control of the airplane.NTSB FTW97LA056Accident · No injuriesLimited investigationFinal reportBeech A23 · Conway, ARthe pilot's inadequate compensation for the crosswind during the landing, and his failure to remain clear of the tree during the attempted go-around. The crosswind and the proximity of the small tree were related factors.NTSB ATL97FA092Accident · 2 fatalField investigationFinal reportCessna 182 · Charleston, SCThe noninstrument-rated pilot's failure to remain clear of instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. A factor was the pilot's failure to obtain a weather briefing.NTSB MIA97LA035Accident · No injuriesLimited investigationFinal reportHoster/Volmer VJ22 (Sportsman) · Seminole, FLinadequate maintenance/inspection of the airplane by the pilot/owner, and fuel contamination that resulted in fuel starvation.NTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.NTSB CHI97WA039Accident · 2 fatalForeign investigationLearjet 36 · Stephenville, IrelandNTSB CHI97LA040Accident · No injuriesLimited investigationFinal reportBeech B55 · Park Rapids, MNthe pilot's high flare. Factors were the icing weather condition and the airframe ice.NTSB ANC97IA011Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Anchorage, AKThe ground crew's failure to maintain communication with the flight crew while loading cargo after pushback and engine start, and the ground and flightcrew's failure to follow the procedure outlined in their manuals concerning use of marshallers during…NTSB SEA97LA036Accident · 2 fatalLimited investigationFinal reportPiper PA18-135 · Cohagen, MTThe pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.NTSB LAX97FA065Accident · 2 fatalField investigationFinal reportOpperman Lancair IV-P · Suisun City, CAIn-flight loss of control for an undetermined reason.NTSB DCA97WA013Incident · No injuriesForeign investigationBoeing 747-236F · Hong Kong, United KingdomNTSB ANC97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Nunapitchuk, AKthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing. Factors associated with the accident were: the low fuel condition, which led to a single engine landing, and the crosswind condition.NTSB IAD97LA028Accident · No injuriesLimited investigationFinal reportHughes 269C · Mayfield, KYdisengagement of the main transmission aft pinion nut, allowing the tail rotor splined drive sleeve to disengage from the pinion, which resulted in loss of directional control and an emergency (autorotative) landing.NTSB IAD97LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Claverack, NYloss of engine power for undetermined reasons.NTSB CHI97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Hudson, MIloss of engine power for undetermined reason(s). Darkness was a related factor.NTSB ANC97LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKthe pilot's improper planning/decision, and resultant failure to obtain/maintain sufficient airspeed during takeoff. A factor related the accident was: taking off with a tailwind.NTSB NYC97FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Felton, PAThe pilot's inadequate preflight planning and preparation, and his failure to refuel which resulted in fuel exhaustion and the subsequent collision with trees during the forced landing.NTSB MIA97LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Homerville, GAcarburetor ice, due to the pilot's improper use of carburetor heat, which resulted in a forced landing and impact with trees.NTSB CHI97LA036Accident · No injuriesLimited investigationFinal reportCessna 177 · Regan, NDthe pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.NTSB NYC97LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Myerstown, PAfatigue failure of the connecting rod to crankshaft attachments, due to inadequate overhaul of the engine by the manufacturer, which resulted in a loss of engine power and a forced landing. Factors relating to the accident included the discharge of oil from…NTSB FTW97LA054Accident · No injuriesLimited investigationFinal reportLet L23 · Bryan, TXthe pilot misjudged his distance and altitude during the landing approach. Factors relating to the accident were: the high obstructions (power lines), and subsequent tailwind during the forced landing.NTSB MIA97LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Sugarloaf Key, FLa complete loss of engine power due to a disconnected connecting rod cap.NTSB LAX97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tusayan, AZFuel exhaustion due to the pilot's inadequate preflight planning and his miscalculation of the fuel required for the flight.NTSB FTW97LA053Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ruidoso, NMfailure of the pilot to maintain directional control during landing roll, and his delayed aborted landing. The gusty crosswind and blown left main tire were considered to be related factors.NTSB ATL97FA021Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Fitzgerald, GAA loss of engine power due to the blockage of the intake manifold of the induction air system, by the broken alternate air door, and the loss of aircraft control for undetermined reasons.NTSB NYC97LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Long Pond, PAThe pilot's inadequate preflight planning/preparation and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related…NTSB LAX97LA058Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Scottsdale, AZdetonation/pre-ignition for unknown reason(s), which resulted in failure of the number two piston, loss of engine power, and a subsequent forced landing on rough/uneven desert terrain.NTSB LAX97IA056Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAa laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.NTSB LAX97FA059Accident · 3 fatalField investigationFinal reportMorane-Saulnier MS760 II · Irvine, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering in a steep banked turn to the landing runway, which resulted in an inadvertent stall/spin. Factors in the accident were: the pilot's inadequate preflight inspection of the aircraft…NTSB IAD97FA025Accident · 1 fatalField investigationFinal reportAero Commander 681 · Mansfield, OHthe pilot's early descent below the minimum descent altitude (MDA), while preparing to land from an instrument approach, and his failure to maintain adequate altitude and clearance from obstruction(s).NTSB ANC97FA009Accident · 2 fatalField investigationFinal reportCessna 185 · Marshall, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and collision with the terrain.NTSB LAX97LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Bear City, CAthe pilot's inadequate compensation for the wind condition, and his failure to maintain alignment with the runway. The gusty crosswind was a related factor.NTSB LAX97LA057Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mcgregor Point, HIthe pilot's failure to maintain control of the aircraft and distance from the pole.NTSB IAD97LA026Accident · Serious injuriesLimited investigationFinal reportCessna 205 · Columbia, PAThe pilot's failure to obtain/maintain airspeed, which resulted in an inadvertent stall, and collision with trees during the initial climb. A factor in the accident was a tailwind condition.NTSB IAD97FA024Accident · Serious injuriesField investigationFinal reportCessna 182P · Fort Washington, MDLoss of engine power for undetermined reason(s).NTSB FTW97LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Floydada, TXThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the locked left main wheel brake.NTSB LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.NTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.NTSB FTW97FA051Accident · 3 fatalField investigationFinal reportEurocopter AS350B2 · High Island A20This case was modified 6/26/2006. The failure of the tail rotor pitch change link due to a fatigue fracture, which resulted in a loss of tail rotor control and separation of the aft tailboom.NTSB LAX97LA054Accident · No injuriesLimited investigationFinal reportCessna 172G · Chino, CAthe pilot's attempt to taxi with a crosswind component well in excess of the aircraft's maximum factory demonstrated capability. The wind conditions were factors.NTSB FTW97LA050Accident · No injuriesLimited investigationFinal reportCessna 172H · Hammond, LAthe pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.NTSB FTW97FA049Accident · 1 fatalField investigationFinal reportBeech A36TC · Tucumcari, NMthe total loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed.NTSB CHI97LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Bowbells, NDthe pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.NTSB ATL97LA027Accident · No injuriesLimited investigationFinal reportBeech 35 · Lafayette, GAfailure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB ATL97LA020Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · St. Petersburg, FLFuel exhaustion for undetermined reasons.NTSB NYC97FA021Accident · 2 fatalField investigationFinal reportCessna 414 · Duo, WVThe pilot's inadequate inflight decision which resulted in VFR flight into instrument meteorological conditions and his failure to maintain adequate terrain clearance which resulted in an inflight collision with terrain. The low ceiling was a factor.NTSB ATL97LA019Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Soperton, GAfailure of the pilot either to attain the proper touch down point for landing or to abort the landing while there was sufficient runway remaining. The terrain (ditch) at the end of the runway was a related factor.