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 ANC97TA096Accident · No injuriesFinal reportPiper PA-18 · Nenana, AKfailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground loop and a collapsed main landing gear. His lack of experience in tailwheel airplanes was a related factor.NTSB SEA97LA157Accident · No injuriesLimited investigationFinal reportCessna 172M · UTUndetermined.NTSB NYC97LA133Accident · No injuriesLimited investigationFinal reportBeech C24R · Old Bridge, NJLoss of engine power for undetermined reasons.NTSB MIA97LA202Accident · 1 fatalLimited investigationFinal reportDFL Holdings Tango · Keystone, FLan in-flight loss of control for undetermined reasons.NTSB LAX97LA229Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Page, AZThe pilot's inadequate compensation for crosswind gusts and his failure to maintain directional control.NTSB ATL97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Smithfield, NCan animal (deer) on the runway. Factors associated with the accident were: the light condition at dusk, and failure or inability of the flight crew to see the deer in time to avoid a collision.NTSB ATL97LA094Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180C · Dyersburg, TNthe pilot's improper planning/decision and failure to insure the that airplane would remain clear of trees during the go-around. Factors relating to the accident included: the high temperature, high density altitude, and the proximity of trees.NTSB SEA97LA156Accident · No injuriesLimited investigationFinal reportStiritz Eipper MX II · Newport, WAThe failure of the owner/builder to adequately inspect his homebuilt aircraft, which subsequently led to the failure of the right wing lift cable attach bolt and resulted in the collapse of the right wing during flight.NTSB NYC97LA132Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Yates, NYThe failure of the cylinder bolts, and the lack of suitable terrain for a forced landing.NTSB NYC97LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Tioga, PAThe pilot's improper inflight decision to land downwind with an inoperative airspeed indicator, and his improper landing flare.NTSB LAX97LA227Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Jacumba, CAThe pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.NTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.NTSB DCA99WA071Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Saudia Arabia, Saudi ArabiaNTSB ATL97LA093Accident · Minor injuriesLimited investigationFinal reportConvair 240-53 · San Juan, PRa loss of engine power for undetermined reasons, the pilot's improper emergency procedure after the powewr loss, and the overloading of the airplane, resulting in an inability to maintain altitude and terrain clearance.NTSB LAX97LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Rimrock, AZFuel starvation due to the pilot's failure to monitor the fuel level in the right tank, and to select a tank containing fuel during the approach and landing in accordance with the checklist.NTSB IAD97LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Block Island, RIThe pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.NTSB FTW97LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gorman, TXthe student pilot's improper inflight planning/decision, and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: a fluctuation in the electrical system, due to an undetermined reason, the student pilot's lack of…NTSB FTW97LA240Accident · Serious injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Ardmore, OKThe pilot's failure to maintain clearance from the power line. Factors were his improper decision to continue the flight after he noted a loss of engine power during initial takeoff climb and the loss of engine power for an undetermined reason.NTSB CHI97LA192Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgregor, MNthe pilot's improper planning/decision, his failure to abort the takeoff while sufficient runway was remaining, and/or his failure to jettison his load in order to achieve sufficient climb rate to clear trees. His lack of certification and training to perform…NTSB CHI97LA190Accident · Serious injuriesLimited investigationFinal reportDietrich Nieuport 12 · Byron, MIThe owner/pilot mechanic's inadequate inspection of the aircraft which led to contamination (other than water) of the fuel filter.NTSB ANC97LA094Accident · No injuriesLimited investigationFinal reportHelio H295 · Ekwok, AKThe pilot's selection of an unsuitable area for takeoff.NTSB ANC97LA093Accident · No injuriesLimited investigationFinal reportDouglas DC-4 · Venetie, AKA fire associated with the number 2 engine for undetermined reasons.NTSB ANC97FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 182F · Talkeetna, AKUndetermined.NTSB SEA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Prineville, ORThe pilot's selection of an unsuitable landing area, his improper decision to attempt an aborted takeoff on a short airstrip surround by rising terrain and trees, and his failure to maintain clearance from the trees during the aborted takeoff attempt. Factors…NTSB NYC97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Frankfort, NYThe pilot's misjudgment of distance and speed on final approach, and his failure to attain the proper touchdown point during landing. A factor in the accident was the night light condition.NTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.NTSB LAX97LA256Accident · No injuriesLimited investigationFinal reportCessna 150F · Casa Grande, AZFailure of the student pilot to maintain directional control.NTSB LAX97FA225Accident · 2 fatalField investigationFinal reportCessna R172K · Moreno Valley, CAThe pilot's continued VFR flight into instrument meteorological conditions, and his attempt to climb through a low stratus cloud layer while in mountainous/hilly terrain. The pilot's failure to obtain a weather briefing, the weather, and the terrain were…NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..NTSB FTW97LA247Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Worth, TXimproper planning/decision by the flight instructor (CFI), which resulted in his inadvertent encounter with jet blast from a twin jet transport airplane.NTSB CHI97LA191Accident · No injuriesLimited investigationFinal reportCessna 402B · Springfield, MOThe pilot-in-command's (CFI) inadequate supervision and failure to take remedial action. A factor was the dual student's failure to maintain directional control.NTSB CHI97LA189Accident · No injuriesLimited investigationFinal reportCessna 172P · Fowlerville, MIfailure of the pilot to either attain proper touchdown point for landing or go around while he had sufficient airspeed and runway remaining.NTSB ATL97LA091Accident · Serious injuriesLimited investigationFinal reportBeech E50 · Tullahoma, TNimproper operation of the engine that produced internal damage, and improper servicing of the airplane by the owner/pilot mechanic that resulted in the subsequent mechanical failure of the engine crankshaft counterweight. Contributing to the accident was the…NTSB ATL97FA090Accident · 1 fatalField investigationFinal reportBeech 35-C33A · Lugoff, SCimproper fuel management by the pilot by not positioning the fuel selector to the fullest tank for landing, which resulted in fuel starvation, loss of engine power, and a forced landing. Trees in the emergency landing area were a factor.NTSB ANC97FA092Accident · 2 fatalField investigationFinal reportCessna 207A · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from an obstruction (antenna tower). Factors in the accident were low ceilings and visibility, and the pilot's lack of familiarity with…NTSB SEA97WA154Accident · Serious injuriesForeign investigationPiper PA-24-250 · Powell River, CanadaNTSB SEA97LA153Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Halls Crossing, UTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting crosswinds.NTSB NYC97LA129Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-1 · Covington, KYthe failure of the primary and secondary elevator driveshafts, and the failure of maintenance personnel to detect the failure of the primary shaft during scheduled inspections.NTSB MIA97LA198Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Bainbridge, GAthe pilot's failure to maintain proper airspeed during the initial climb after takeoff, and improper flare during an emergency (precautionary) landing, which resulted in a hard touchdown and subsequent nose over. Factors related to the accident were: the…NTSB MIA97LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW97LA309Accident · No injuriesLimited investigationFinal reportBeech F33A · Monroe, LAan electrical short, which burned a hole in a fuel line, and subsequent fire from the burning fuel.NTSB FTW97LA241Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clovis, NMThe pilot's failure to maintain aircraft control. A factor was an unexpected gust of wind during landing touch down.NTSB FTW97LA239Accident · No injuriesLimited investigationFinal reportCessna 210 · Peyton, COFailure of both pilots to assure the landing gear was down and locked.NTSB FTW97LA238Accident · No injuriesLimited investigationFinal reportCessna 305A · Watkins, COThe pilot inadvertently stalling the airplane at an altitude insufficient for a safe recovery. A factor was the tailwind.NTSB FTW97LA237Accident · Serious injuriesLimited investigationFinal reportRans S-12 Airaile S-12 · Fort Collins, COAttempt by the pilot to fly the aircraft with the center of gravity out of limits. A factor was a disconnected lift strut support cable.NTSB FTW97LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Leadville, COan attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.NTSB CHI97LA186Accident · Minor injuriesLimited investigationFinal reportHulliberger Starduster II · Berrien Springs, MIthe failure of the landing gear axle due to fatigue.NTSB CHI97LA185Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Manito, ILloss of engine power for undetermined reason(s).NTSB ANC97TA095Accident · No injuriesFinal reportPiper PA-18-180 · Tok, AKThe second pilot/dual student's failure to maintain a proper glidepath, and the pilot-in-command/flight instructor's inadequate supervision. A factor associated with the accident was a downdraft.NTSB SEA97LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Ogden, UTThe fracture of the no. 4 exhaust valve and subsequent loss of engine power. Factors contributing to the accident include a congested landing area, and rough terrain.