NTSB investigations, 1997
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1997 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") = 1997 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 CHI98LA049Accident · No injuriesLimited investigationFinal reportKing Avid Flyer C · Minneapolis, MNThe pilot's failure to maintain directional control. A related factor was the crosswind.NTSB ATL98LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Summerland Key, FLthe pilot's inadequate compensation for the wind conditions and failure to flare the airplane for landing. The gusty crosswind was a related factor.NTSB ATL98FA017Accident · 4 fatalField investigationFinal reportMark Ewart Velocity Standard RG · Florence, SCimproper maintenance procedures used by the pilot/repairman, which resulted in the loosening and eventual failure of the propeller. Factors relating to the accident were: the pilot's self-imposed pressure to hurry to the destination, and trees in the forced…NTSB SEA98LA017Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Canby, ORThe pilot's allowance of excessive airspeed resulting in the long-line hook impacting the tail rotor, and his allowance of an airspeed bleed-off preventing a successful run-on landing due to a loss of yaw control.NTSB SEA98LA016Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Billings, MTThe co-pilot's failure to maintain the proper descent rate on final approach, the pilot-in-command's delayed remedial action, and overload of the left main landing gear assembly. Factors contributing were snow, crosswind conditions and deteriorating…NTSB NYC98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Middlefield, OHloss of engine power for undetermined reasons.NTSB LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…NTSB DCA98RA009Accident · 9 fatalForeign investigationBell UH-1H · La Palma, PanamaNTSB CHI98LA051Accident · No injuriesLimited investigationFinal reportBeech E55 · Gardner, KSthe inadvertant landing gear retraction, which occurred due to undetermined reason(s).NTSB CHI98LA047Accident · No injuriesLimited investigationFinal reportHall RV-6 · Blair, NEa fatigue failure of the torque tube outside of the weld and the fractured pilot's side left rudder pedal.NTSB CHI98FA048Accident · 1 fatalField investigationFinal reportCessna 172E · Topeka, KSthe pilot's improper use of carburetor heat. Contributing factors were carburetor icing conditions, dark night conditions, and the transmission wire.NTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.NTSB LAX98LA044Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · San Martin, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.NTSB LAX98FA043Accident · 1 fatalField investigationFinal reportCessna 172N · La Jolla, CAthe pilot's act of suicide by intentionally diving his aircraft into the ocean.NTSB IAD98FA012Accident · 2 fatalField investigationFinal reportCessna 182A · New Dover, OHThe pilot's attempted VFR flight into instrument conditions and the loss of aircraft ctontrol subsequent to the pilot's spatial disorientation. Contributing factors were low ceilings, snow and the pilot's failure to obtain a preflight weather briefing, as…NTSB FTW98LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COloss of engine power for undertermined reason(s).NTSB FTW98LA058Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Lecompte, LAa loose battery cover, due to improper installation by maintenance personnel, that became jammed with an elevator control rod and restricted the movement of the elevator control system, which subsequently led to an uncontrolled impact with a tree, shortly…NTSB FTW98LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, TXthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, while landing. The gusty crosswind was a related factor.NTSB FTW98FA056Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Royse City, TXThe pilot's impairment due to drugs, and his ensuing failure to maintain minimum required airspeed for flight, which resulted in a stall/spin. A factors was the loss of power to both engines due to fuel starvation as a result of the pilot's improper use of…NTSB CHI98LA046Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Lincoln, NEthe throttle linkage coming apart in flight, and the inadvertent stall.NTSB CHI98LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, ILthe pilot's failure to see-and-avoid the powerlines on short final. The location of the powerlines was a related factor.NTSB NYC98LA031Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tiverton, OHthe pilot's failure to properly set the airplane controls prior to hand propping. Factors in the accident were the pilot's failure to properly chock the wheels and his decision to leave the cockpit unmanned during start.NTSB FTW98LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Midlothian, TXfatigue failure of the #2 cylinder fuel injection line in an area where the line was previously damaged, which resulted in an in-flight engine compartment fire and a forced landing. Related factors were: the previous damage of the fuel injector line, and the…NTSB DCA98WA039Incident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Paris, FranceNTSB CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.NTSB ATL98LA022Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Fort Lauderdale, FLThe undetermined malfunction of the right brake and the pilot's failure to maintain directional control during the landing rollout. A factor was the quartering tailwind.NTSB ATL98LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Waycross, GAa loss of engine power for undetermined reasons.NTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.NTSB LAX98LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAthe flight instructor's failure to thoroughly brief his student on the performance standards of the proposed autorotation and the method to be used for a positive transfer of controls. The student's failure to verify the performance standards of the…NTSB LAX98LA041Accident · Minor injuriesLimited investigationFinal reportRans S91 · Phoenix, AZThe pilot's failure to maintain an adequate airspeed margin during the forced landing, which resulted in an inadvertent stall/mush.NTSB CHI98LA056Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Nevada, MOa deer that ran onto the runway as the airplane was landing. The reduced light condition at dusk was a related factor.NTSB CHI98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Janesville, WIthe dual student's failure to obtain the proper touchdown point, and the instructor's failure to provide adequate supervision of the flight. Factors associated with the accident were: inadequate altitude, the student's diverted attention, the snowbank, and…NTSB ATL98LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Opa Locka, FLthe pilot's continued flight into adverse weather conditions, and failure to maintain clearance above the ground while attempting a VFR approach to an airport with low clouds. The low clouds (ceiling) and condition of light at dusk were related factors.NTSB ATL98LA012Accident · No injuriesLimited investigationFinal reportRoebuck Rans S-10 Sakota · Columbia, SCthe airplane builder's improper routing of vinyl/plastic cooling/vent line(s) for the engine oil system, and improper materials supplied by the manufacturer, which led to overheating of the line(s) in the engine compartment and an in-flight fire.NTSB CHI98LA053Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-15 · Syracuse, NYThe pilot's inadequate preflight to ensure that the cargo pallets were properly secured. Also causal was the the improper securing of the pallets.NTSB CHI98LA042Accident · No injuriesLimited investigationFinal reportMooney M20K · Eden Prairie, MNthe pilot's improper decision to continue the approach beyond decision height, when he could not see the runway; and his attempt to land without being properly aligned on the runway. Factors relating to this accident were: darkness, fog and and runway lights.NTSB ATL98LA011Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Athens, GAthe pilot's improper in-flight planning/decision by attempting to land in weather that was below minimums, and his failure to attain a suitable touchdown point on the runway. Weather below landing minimums was a related factor.NTSB MIA98IA035Incident · No injuriesIncident investigationFinal reportDouglas DC-8F-55 · Miami, FLThe inadequate overhaul of the No. 4 engine start valve resulting in the valve remaining open after engine start; and the subsequent free run state of the starter resulting in a starter overheat, disintegration and fire.NTSB FTW98LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Tajique, NMThe loss of engine power due to carburetor ice. Factors included unsuitable terrain, and dark night conditions.NTSB CHI98LA041Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Burlington, KSan undetermined event resulting in the door seal inflation pump catching fire, the pilot's failure to close the cockpit air vents allowing heat and flames from the airplane's nose section to melt electrical wiring behind the instrument panel, and the pilot…NTSB CHI98LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Salem, INthe pilot's misjudgment of distance and altitude, while on final approach to land at night. Factors relating to the accident included: an undetermined electrical malfunction, inoperative flaps, darkness, the pilot not using the landing light, and the…NTSB ATL98LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.NTSB NYC98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mount Holly, NJThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC98LA029Accident · Serious injuriesLimited investigationFinal reportBeech E33A · Westminster, MDthe pilot's improper in-flight planning/decision, his misjudgment of speed and distance while on final approach to land, and his delay in aborting the landing after failing to attain a proper touchdown point for landing.NTSB FTW98TA052Accident · Serious injuriesFinal reportCessna 310J · Beaumont, TXThe pilot's failure to maintain control for undetermined reasons. A factor may have been an encounter with wake turbulence.NTSB FTW98LA053Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tomball, TXThe total loss of engine power resulting from the loss of oil and resultant seizure of a cylinder due to inadequate maintenance by maintenance personnel. A factor was the lack of suitable terrain for the forced landing and the low ceiling.NTSB MIA98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palatka, FLthe student pilot's failure to properly secure the oilcap/dipstick within it's integral oil filler tube during his preflight inspection.NTSB MIA98LA027Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Spruce Pine, NCThe unintentional locking-up of the left brake for undetermined reasons resulting in the on ground loss of control. Contributing to the accident was the inability of the pilot to maintain directional control.NTSB LAX98LA040Accident · No injuriesLimited investigationFinal reportAero Commander 200D · San Carlos, CAThe pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.NTSB DCA98WA007Accident · Minor injuriesForeign investigationMcDonnell Douglas DC-8F · Mwanza Airport, Tanzania