NTSB investigations, 1997
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.NTSB LAX97LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-18A · Livingston, CAthe pilot's failure to see and avoid power lines. A factor was the pilot's poor judgment in conducting unwarranted low altitude maneuvering.NTSB FTW97LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Rogers, ARthe pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).NTSB DCA97WA029Incident · No injuriesForeign investigationBoeing 737 · Panama City, PanamaNTSB CHI97TA070Accident · No injuriesFinal reportCessna 172 · Oconto, WIthe failure of the pilot to maintain proper runway alignment and thus clearance with the snow drifts during takeoff. A factor was the distance the snow drifts extended past the runway edge.NTSB NYC97LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's failure to maintain the airplane on the ILS glide slope, which resulted in a descent below the glide path, and the inadvertent in-flight collision with a utility pole. Contributing factors were sleet/snow, dark night conditions, and the pole.NTSB LAX97LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · San Pablo Bay, CAtotal loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB ATL97IA042Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Atlanta, GAfailure of ground service personnel to properly close the aft cargo door before the airplane departed.NTSB ATL97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Winston Salem, NCthe pilot's inadequate compensation for wind conditions and failure to maintain directional cntrol of the airplane, which resulted in a ground swerve and collapse of the right main landing gear. The crosswind was a related factor.NTSB MIA97WA100Accident · 1 fatalForeign investigationCessna T210 · Challao, ArgentinaNTSB LAX97LA102Accident · No injuriesLimited investigationFinal reportGreen Cozy III · San Martin, CAA loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.NTSB LAX97FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-161 · Avalon, CAundetermined.NTSB FTW97LA102Accident · Serious injuriesLimited investigationFinal reportCessna 210-5 · Hobbs, NMThe loss of engine power due to fuel starvation for undetermined reasons. A factor was the pilot's continued flight after a fuel consumption anomaly was encountered.NTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.NTSB NYC97LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-44-180T · Caldwell, NJThe pilot's incapacitation due to a heart attack.NTSB LAX97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Madera, CAThe pilot's failure to maintain adequate clearance from obstructions and his inadequate visual outlook.NTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.NTSB MIA97FA082Accident · 2 fatalField investigationFinal reportCessna 402C · St. ThomasThe failure of the pilot to maintain altitude while making a visual approach at night over water in black hole conditions resulting in the aircraft descending and crashing into the sea. Contributing to the accident was the failure of the pilot and operator to…NTSB LAX97LA101Accident · No injuriesLimited investigationFinal reportCessna 210H · Big Bear City, CAa corroded landing gear down limit switch, which resulted in a retracted left main gear during the landing sequence.NTSB LAX97LA099Accident · No injuriesLimited investigationFinal reportAyres S2R-T65 · Firebaugh, CAfailure of the pilot to compensate for crosswind conditions and to maintain proper runway alignment. Factors relating to the accident were: the crosswind, narrow runway condition, and the soft terrain and ditch beside the runway.NTSB LAX97LA097Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Los Angeles, CAFuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.NTSB DCA97WA025Accident · No injuriesForeign investigationBoeing B-737-300 · Nurnberg/Gerf, GermanyNTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB MIA97LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Homosassa, FLthe unqualified person's poor judgment, by taking the helicopter without the owner's permission and attempting an unauthorized flight at night; and his failure (or inability) to maintain control the helicopter. Darkness was a related factor.NTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.NTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.NTSB ANC97FA026Accident · 1 fatalField investigationFinal reportPiper PA-18 · Circle, AKinadequate preflight by the pilot; and his subsequent loss of aircraft control, during the initial climb after takeoff. Factors relating to the accident were: the pilot failed to ensure that the cargo was properly secured, and he allowed the aircraft's weight…NTSB SEA97LA058Accident · No injuriesLimited investigationFinal reportCessna 421C · Cedar City, UTwater contamination in the hydraulic system, which froze in the (right) main gear hydraulic actuator, and restricted movement of the (right) main gear retraction and extension system.NTSB DCA97LA027Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600R · St John Antigua, Antigua & BarbudaThe captain failed to establish and maintain a stabilized approach (or perform a go-around), and applied excessive pitch rotation during the subsequent recovery from a bounced landing, resulting in a tail strike. A factor contributing to the accident was the…NTSB ATL97LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLA loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.NTSB FTW97RA101Accident · 1 fatalForeign investigationBeech 23 · Santa Catarina, MexicoNTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.NTSB FTW97FA100Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Lone Wolf, OKthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, and his failure to maintain sufficient altitude (clearance above a lake), while performing aerobatic flight. Factors relating to the accident were: the…NTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.NTSB ATL97LA038Accident · No injuriesLimited investigationFinal reportBeech 23 · Palatka, FLfailure of the nose gear for undetermined reason(s).NTSB SEA97LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Moorcroft, WYThe pilot's failure to maintain adequate airspeed. A factor was the pilot's low altitude flight and maneuvering.NTSB SEA97LA055Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bandon, ORthe dual student's failure to maintain directional control of the airplane, and the flight instructor's improper remedial action. A factor relating to the accident was: the ravine located near the right side of the runway.NTSB NYC97LA052Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cincinnati, OHThe flight instructor's inadequate supervision and delayed remedial reaction which resulted in the loss of directional control by the student pilot during the landing roll out.NTSB NYC97LA050Accident · No injuriesLimited investigationFinal reportBerry Vans RV-4 · York, PAthe pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.NTSB MIA97LA081Accident · Serious injuriesLimited investigationFinal reportCessna A150L · St. Mary'S, GAthe pilot's failure to maintain airspeed which resulted in an inadvertent stall the at too low an altitude to allow recovery. A factor in this accident was the pilot's attention was diverted.NTSB LAX97LA096Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Payson, AZa loss of engine power for undetermined reasons.NTSB CHI97LA063Accident · No injuriesLimited investigationFinal reportBeech B200 · Marshall, MNthe pilot inadvertently putting the gear selector switch in the up position during landing.NTSB MIA97WA089Accident · Minor injuriesForeign investigationPiper PA-18 · Valparaiso, ChileNTSB MIA97LA080Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sarasota, FLthe pilot's failure to maintain clearance from obstacles.NTSB MIA97LA079Accident · No injuriesLimited investigationFinal reportBeech V35 · Orlando, FLloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB MIA97LA078Accident · No injuriesLimited investigationFinal reportRichards Velocity 173 RG · Valkaria, FLa loss of engine power for undetermined reasons.NTSB MIA97LA077Accident · 1 fatalLimited investigationFinal reportBeech 95-B55 · Monroe, NCpilot incapacitation as result of Ischemic heart disease.NTSB FTW97LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Waxahachie, TXThe loss of engine power for undetermined reasons. A factors was the lack of suitable terrain for the forced landing.