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 ATL97LA073Accident · 1 fatalLimited investigationFinal reportCapstaff Challenger II · Southern Pines, NCThe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain clearance from obstacles.NTSB ANC97LA077Accident · No injuriesLimited investigationFinal reportCessna 180 · Shaktoolik, AKloss of engine power for undetermined reason(s).NTSB ANC97LA076Accident · Minor injuriesLimited investigationFinal reportCessna 180F · Ketchikan, AKthe pilot's inadequate compensation for wind conditions. A factor relating to the accident was: the unfavorable wind condition with gusts and downdrafts.NTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.NTSB LAX97LA186Accident · No injuriesLimited investigationFinal reportCessna 150 · Groveland, CAwas fuel exhaustion. Contributing to the accident was the lack of preflight review by the student's flight instructor and training.NTSB FTW97RA194Accident · 4 fatalForeign investigationRockwell 1121B · La Carbonera, MexicoNTSB CHI97LA142Accident · No injuriesLimited investigationFinal reportMooney M20F · Wheeling, ILbinding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.NTSB CHI97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas the pilot not maintaining sufficient altitude to clear obstructions. A factor associated with the accident was the pilot was inattentive to the airplane's altitude.NTSB ATL97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sparta, TNA fire in the left engine started by a leak in the fuel pump.NTSB MIA97LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Venice, FLfailure of the pilot to maintain sufficient airspeed on final approach and during the landing to properly flare the airplane.NTSB LAX97WA194Accident · No injuriesForeign investigationCessna 180 · Rancho Santa Yn, MexicoNTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.NTSB FTW97FA193Accident · 1 fatalField investigationFinal reportPezetel M-18A · Wilmot, ARfailure of the pilot to remove the elevator control lock before the first flight of the day, which resulted in his inability to control the airplane, due to the locked elevator control. Related factors were: the prevailing high winds and the lack of a visible…NTSB SEA97LA113Accident · No injuriesLimited investigationFinal reportCessna 207 · Roche Harbor, WAThe pilot's inadequate remedial action upon encountering a downdraft on final approach. The downdraft was a factor.NTSB NYC97LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Galion, OHThe inadvertent encounter with the helicopter main rotor downwash during the initial takeoff climb. Subsequently, the airplane descended and impacted the ground.NTSB MIA97LA169Accident · No injuriesLimited investigationFinal reportCessna Wren 182G-460 · Spartanburg, SCthe pilot's inadequate preflight planning/preparation, by failure to survey the takeoff area, and his delay in aborting the takeoff. Upsloping terrain and high vegetation in the takeoff area were related factors.NTSB LAX97LA185Accident · 1 fatalLimited investigationFinal reportBell 206B · Hilo, HIthe noninstrument-rated pilot flew into instrument conditions and failed to maintain adequate terrain clearance, while attempting to descend through an overcast. The adverse weather conditions and mountainous terrain were related factors.NTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.NTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.NTSB CHI97LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Flushing, MIthe pilot's misjudgment of distance and speed on final approach, his failure to attain the proper touchdown point for landing, and his delay in initiating a go-around (aborted landing). Factors related to the accident were: darkness, and the proximity of…NTSB CHI97LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Angola, INthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the tailwind, the pilot's selection of runway, and the misjudged landing flare.NTSB CHI97FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Savoy, ILthe pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.NTSB ANC97LA082Accident · No injuriesLimited investigationFinal reportCessna TU206A · Yakutat, AKthe pilot's selection of unsuitable terrain for landing.NTSB ANC97LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKfailure of the pilot to maintain directional control of the airplane during a touch-and-go landing. Factors associated with the accident were: the rough/uneven runway, and a berm.NTSB MIA97LA168Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLThe pilot misjudging the distance of the intended touchdown point resulting in his intentional decrease in the main rotor rpm to clear obstacles below. Contributing to the accident was the total loss of engine power due to undetermined reasons.NTSB LAX97LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Henderson, NVthe pilot's attempt to land the aircraft under crosswind conditions that exceeded the performance capability of the aircraft.NTSB IAD97LA078Accident · No injuriesLimited investigationFinal reportMooney M20M · Madisonville, KYFailure of the pilot to maintain adequate airspeed, and inadequate supervision of the CFI, which resulted in a stall and subsequent hard landing.NTSB ANC97TA074Accident · No injuriesFinal reportSchweizer SGS 1-26E · Fort Wainwright, AKthe pilot's inadequate preflight and improper planning/decision. Factors relating to the accident were: an unlatched canopy, and unsuitable terrain for landing.NTSB SEA97LA115Accident · No injuriesLimited investigationFinal reportRobinson R22B · Boise, IDimproper handling of the helicopter by the student pilot/applicant, during a hover autorotation, which resulted in loss of tail rotor effectiveness. The check pilot's inadequate remedial action was a related factor.NTSB SEA97LA114Accident · No injuriesLimited investigationFinal reportCessna T207A · Monument Valley, UTA horse entering the runway after the aircraft touched down. Factors included no fence installed around part of the airstrip, and remedial action not possible.NTSB SEA97LA109Accident · Minor injuriesLimited investigationFinal reportLearjet 35A · Great Falls, MTthe captain's inadequate preflight planning/preparation, and the subsequent improper response to a simulated loss of engine power, resulting in liftoff at an airspeed below that for which sustained flight was possible.NTSB NYC97LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Red Hook, NYThe pilot's improper compensation for the wind conditions and his failure to initiate a go-around.NTSB NYC97FA092Accident · 1 fatalField investigationFinal reportCessna T337G · North Dansville, NYthe pilot's improper decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance from rising/wooded terrain. The adverse weather conditions and rising wooded terrain were related factors.NTSB MIA97LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Ball Ground, GAfailure of the pilot to maintain directional control during the takeoff roll and his failure to abort the takeoff before colliding with an embankment.NTSB MIA97LA166Accident · Serious injuriesLimited investigationFinal reportTravis C. Elmore B2B/582 · Haines City, FLThe pilots inadvertent activation of the rear carburetor choke lever during routine engine maintenance the day before the accident. Contributing to the accident was the unsuitable terrain encountered during the forced landing and also failure of the engine…NTSB CHI97LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIthe pilot's inadequate compensation for wind conditions which resulted in a loss of directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions and the VASI lights.NTSB SEA97LA112Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Snohomish, WAthe pilot's encounter with of a loss of tail rotor effectiveness (LTE) situation, and his subsequent inadequate remedial action. Related factors included: wind conditions that were conducive to an unanticipated right yaw event, and the pilot's limited…NTSB FTW97LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28R-210T · Fort Collins, COthe pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…NTSB CHI97IA134Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Saint Louis, MOfailure of company maintenance personnel to properly install a mounting eyebolt (and associated cotter pin, washer, spacer and castellated nut) on the lower forward bracket of the left main landing gear strut door.NTSB MIA97WA164Accident · No injuriesForeign investigationPiper PA-34-200T · Cotton Bay, BahamasNTSB MIA97LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Vero Beach, FLfailure of the pilot to ensure all articles in the aircraft were secured before flight, and subsequently, an oil can becoming lodged under the rudder pedals and preventing her from controlling the aircraft during landing.NTSB MIA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Yakkama City, FLa complete loss of engine power due to the separation of the connecting rod bolts, resulting in a forced landing and impact with a tree. A factor in this accident was improper installation of the rod bolts by a mechanic.NTSB MIA97FA162Accident · 1 fatalField investigationFinal reportCessna R182 · N. Myrtle Beach, SCthe pilot's failure to maintain airspeed during a go-around resulting in an inadvertent stall.NTSB LAX97LA179Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Truckee, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuccessful attempt to release the long line from the belly hook after it became entangled in a tree.NTSB IAD97LA075Accident · No injuriesLimited investigationFinal reportCessna 180J · Lebanon, NHThe loss of engine power for undetermined reasons.NTSB FTW97LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Weatherford, TXloss of engine power for undetermined reason(s). Uneven terrain beyond the end of the runway was a related factor.NTSB DCA97WA047Accident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomNTSB SEA97LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeland, WAFuel exhaustion due to the flight instructor's failure to insure there was proper fuel in the aircraft and the flight instructor's misjudgment of his altitude and airspeed while executing a power-off forced landing in a large open field. Factors include: a…NTSB NYC97LA095Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe vehicle's driver failure to maintain adequate clearance from and resulted in a collision with a parked aircraft.NTSB NYC97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Morristown, NJThe flight instructor's inadequate supervision which allowed the student to solo at night with less than one hour of night instruction with a known inoperative landing and taxi light. A Factor was the student pilot's spatial disorientation which resulted in…