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 CHI97FA102Accident · 2 fatalField investigationFinal reportCessna T210N · Vichy, MOfailure of the pilot to properly follow the missed approach procedure and maintain the minimum descent altitude (MDA) during night/IFR flight. Factors relating to the accident included: darkness, low ceiling, fog, and failure of the pilot to properly…NTSB ANC97LA056Accident · No injuriesLimited investigationFinal reportBoeing 747-400 · Anchorage, AKAn in-flight collision with a large bird.NTSB ANC97LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Quinhagak, AKA disconnected exhaust manifold collector, improper maintenance of the airplane by company maintenance personnel, and the pilot's poor judgement in electing to initiate another flight after observing smoke in the cockpit.NTSB MIA97LA137Accident · No injuriesLimited investigationFinal reportCessna 185D · Wetumpka, ALloss of engine power during a go-around for undetermined reason(s).NTSB LAX97FA156Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-300 · Minden, NVloss of aircraft control for undetermined reason(s), inadequate design of the canopy jettison system, and incapacitation of the pilot, when he was struck by the canopy frame during a jettison sequence.NTSB ANC97MA161Accident · 5 fatalMajor investigationFinal reportCessna 208B · Wainwright, AKThe pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain altitude/clearance from terrain. Factors contributing to the accident were the weather conditions.NTSB ANC97LA054Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Manokotak, AKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall of the airplane. A factor associated with the accident was the pilot's performance of a low altitude flight maneuver.NTSB MIA97LA134Accident · No injuriesLimited investigationFinal reportNavion A · Quincy, FLchafing of an electrical cable that was routed through the firewall, which resulted in electrical arching and an in-flight fire.NTSB MIA97LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · La Crosse, FLThe student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…NTSB MIA97LA130Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Lake Wales, FLThe partial loss of engine power for undetermined reasons.NTSB MIA97LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAThe student pilot's failure to maintain directional control during a crosswind landing. The winds were a factor.NTSB MIA97LA127Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Tullahoma, TNFuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…NTSB LAX97LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Pacific Ocean (Pacific Ocean)The loss of engine power in one engine for undetermined reasons. A factor in the accident was the aircraft's diminished single engine performance during the early portion of the overweight ferry flight.NTSB DCA97WA039Accident · 10 fatalForeign investigationCessna 414 · Zurich, SwitzerlandNTSB CHI97GA103Accident · Serious injuriesFinal reportBell OH-58A · Seymour, INimproper action(s) by one or more of the emergency response team members, during a hovering/loading sequence, which resulted in the helicopter's lateral center-of-gravity (CG) limitations to be exceeded. A factor associated with the accident was: the pilot's…NTSB ANC97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Alsworth, AKloss of engine power, due to failure of the number 2 connecting rod assembly (rod, bearing, & bolts). The lack of suitable terrain for a forced landing was a related factor.NTSB NYC97LA072Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Vincentown, NJThe pilot's failure to maintain directional control, which resulted in an on ground loss of control. A contributing factor was a crosswind.NTSB MIA97LA132Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bushnell, FLThe pilot's failure to maintain a visual lookout and altitu de while on final approach to landing resulting in an in-flight collision with a fence and subsequent collision with terrain.NTSB MIA97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Stuart, FLThe pilot's failure to maintain directional control during a crosswind landing. Factors were the crosswind and his improper level off.NTSB MIA97LA125Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC10-30F · Memphis, TNA stall buffet or a high speed buffet event which occurred at an undetermined time.NTSB LAX97LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper runway alignment.NTSB IAD97LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Annapolis, MDThe pilot's failure to raise the flaps during the go-around. Factors involved were the high wind conditions and the pilot's failure to remove the carburetor heat.NTSB CHI97LA101Accident · Serious injuriesLimited investigationFinal reportAeronca 7CCM · Carson, NDa loss of engine power due to ice in the fuel line. A factor was inadequate maintenance and inspection.NTSB ANC97FA051Accident · 2 fatalField investigationFinal reportCessna 185 · Tatitlek, AKThe command pilots of both airplanes inadequate visual outlook which led to their failure to see and avoid each other's airplane. A factor associated with the accident was sunglare.NTSB MIA97LA123Accident · No injuriesLimited investigationFinal reportCumberland Skybolt · Smithfield, NCInstallation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…NTSB MIA97LA120Accident · 1 fatalLimited investigationFinal reportBasinski Kolb MK3 · Winter Haven, FLfailure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.NTSB MIA97GA119Accident · Serious injuriesFinal reportAerospatiale AS 350B · West Palm Beach, FLFailure of the pilot-in-command to recognize that the main rotor rpm was decreasing and his failure to maintain the main rotor rpm during the autorotative landing resulting in a hard landing. Contributing to the accident was the partial loss of engine power…NTSB IAD97FA064Accident · 2 fatalField investigationFinal reportCessna 414 · Hillsboro, OHfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an advertent stall and collision with trees, vehicles, and the terrain.NTSB NYC97LA071Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Newark, NJan encounter with unforecasted turbulence, during cruise flight, which resulted in serious injury to the flight attendant.NTSB MIA97LA116Accident · No injuriesLimited investigationFinal reportRosen ONE Design · Lakeland, FLThe pilot's improper recovery from a bounced landing.NTSB LAX97LA144Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Knights Landing, CAthe pilot's failure to maintain minimum control airspeed during the approach. Contributing to the accident was the pilot's failure to maintain directional control after landing.NTSB LAX97FA149Accident · No injuriesField investigationFinal reportAerospatiale AS350D · Los Angeles, CAthe pilot's failure to ensure that the collective lock was properly seated before deplaning.NTSB FTW97TA154Accident · No injuriesFinal reportBell TH-13T · Capitan, NMloss of engine power for undetermined reason(s).NTSB FTW97LA157Accident · No injuriesLimited investigationFinal reportBeech BE-95 · San Antonio, TXThe failure of the right main gear due to improper repair by the company maintenance personnel.NTSB FTW97LA156Accident · No injuriesLimited investigationFinal reportRockwell 114 · Oklahoma City, OKThe exhaust manifold cracking due to the pilot's inadequate maintenance modification of the exhaust system which resulted in a fire. A factor was the lack of suitable terrain for the forced landing.NTSB ANC97LA048Accident · No injuriesLimited investigationFinal reportPiper PA-31-T3 · Stebbins, AKThe pilot's decision to continue VFR into IMC. Factors associated with the accident are fog/obscuration, and the pilot's failure to initiate a go-around earlier in the approach.NTSB SEA97LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Portland, ORthe flightcrew's inadequate preflight, and the ramp agent's inadequate dispatch of the aircraft. The unsecured cargo door was a factor.NTSB SEA97LA084Accident · Minor injuriesLimited investigationFinal reportHutton Rand Robinson KR-2 · Grants Pass, ORThe pilot's failure to adequately compensate for wind conditions, his failure to maintain directional control on takeoff, and his failure to abort the takeoff. Factors contributing to the accident are gusty crosswinds.NTSB SEA97LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Arlington, WAThe failure of the commercial pilot to perform an adequate visual lookout while on final approach for landing on the runway, and the failure of the student pilot of the other airplane to perform an adequate visual lookout prior to taking off from the same…NTSB NYC97FA069Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Farmingville, NYthe pilot's improper inflight planning/decision, which subsequently resulted in fuel exhaustion and loss of engine power. Related factors were: excessive fuel consumption rate, and obstructions (trees and house) in the emergency landing area.NTSB MIA97LA122Accident · Minor injuriesLimited investigationFinal reportKunc KR-1 · Deland, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel to safety complete the flight, which resulted in fuel exhaustion, loss of engine power, a forced landing, and subsequent collision with tree(s).NTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB MIA97LA115Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Columbia, SCThe pilot's inadequate planning/decision and failure to assure an adequate supply of fuel was on board the airplane.NTSB LAX97LA153Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Healdsburg, CAThe loss of pressure in the landing gear normal brake system for undetermined reasons requiring the pilot to make an intentional ground loop to stop the aircraft.NTSB LAX97FA148Accident · 1 fatalField investigationFinal reportCessna 152 · S. Lake Tahoe, CAThe pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…NTSB IAD97WA067Accident · No injuriesForeign investigationGulfstream G1 · Goma, UgandaNTSB FTW97LA153Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marietta, OKThe pilot's inadequate short field takeoff. A factor was the pilot's lack of recent experience in short field takeoffs from a grass/turf runway.NTSB CHI97LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Olathe, KSthe pilot's improper inflight planning/decision and exceeding the airplane recommended crosswind component. Factors associated with this accident were the weather conditions of a high wind, gusts, and a crosswind.NTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.NTSB MIA97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLthe pilot's improper compensation for wind conditions and failure to properly flare the airplane for landing. Factors relating to the accident were: the gusty/quartering wind conditions, and the pilot's improper use of flaps for landing.