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 LAX98LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Payson, AZThe pilot's selection of a downwind direction to land and his failure to compensate for the quartering tailwind condition.NTSB FTW98LA040Accident · No injuriesLimited investigationFinal reportCessna 172G · Elk City, OKThe high winds and the pilot's poor judgment in attempting to taxi in the existing wind conditions.NTSB FTW98LA039Accident · No injuriesLimited investigationFinal reportCessna 175 · Arnaudville, LAa cracked fuel line, which allowed air to enter the line and lead to fuel starvation and loss of engine power. A related factor was: the lack of suitable terrain for a forced landing.NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB CHI98FA031Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lynn, INthe pilot's failure to maintain control of the airplane which resulted in the inflight separation of the wings, vertical stabilizer/rudder, and the stabilator. Factors associated with the accident the pilot continued the flight into known adverse weather and…NTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.NTSB MIA98LA018Accident · 1 fatalLimited investigationFinal reportSaldairiaga Buccaneer II · Clermont, FLfailure of the pilot to maintain adequate airspeed, while maneuvering at a low altitude, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.NTSB MIA98LA017Accident · Serious injuriesLimited investigationFinal reportde Havilland DH-8-201 · Jacksonville, FLThe passengers failure to secure her seatbelt as directed by the flight crew (seatbelt sign illuminated) on initial takeoff climb resulting in her ejection from her seat during an encounter with turbulence.NTSB LAX98LA037Accident · No injuriesLimited investigationFinal reportRodgers/Gaust RV-6 · Wellington, NVFuel starvation due to a fatigue fractured mixture control cable. Contributing factors were the soft, brush-covered emergency landing field.NTSB FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.NTSB FTW98LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · Tooele, UTfailure of the pilot to maintain directional control of the airplane, while landing. Factors related to the accident were: the pilot's improper flare for landing, his delay in attempting to go around (abort the landing), and the encounter with a runway marker…NTSB FTW98LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Galveston, TXinadequate maintenance and/or preflight inspection of the airplane, and subsequent blockage of the fuel filters, which led to fuel starvation, partial loss of engine power in both engines, and a forced landing. A related factor was the lack of suitable…NTSB NYC98LA025Accident · No injuriesLimited investigationFinal reportHughes 269B · Cleveland, OHthe pilot's failure to recover from settling-with-power. Factors relating to the accident were: the pilot's downwind approach and low airspeed.NTSB NYC98FA024Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Fitchburg, MAThe flight instructor's inadequate in-flight decision and his failure to maintain adequate airspeed which resulted in a loss of control. Contributing was the flight instructor's failure to follow standard practices while simulating and practicing emergency…NTSB LAX98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Santa Rosa, CALoss of engine power for undetermined reasons.NTSB CHI98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Lakeville, MNfuel starvation due a deteriorated grommet in an Adel clamp, and a loose mixture control cable.NTSB ANC98LA009Accident · No injuriesLimited investigationFinal reportCessna 185F · Barrow, AKThe pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff. A factor in the accident was the presence of gravel/sand in the takeoff area.NTSB NYC98LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Salisbury, MDThe student pilot's improper flare which resulted in a hard landing.NTSB IAD98LA009Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Smoketown, PAThe pilot in command's (CFI) improper management of the fuel supply, which resulted in fuel exhaustion of the selected tank and the subsequent loss of engine power.NTSB DCA98RA008Accident · 2 fatalForeign investigationBoeing 234 · Comox Lake, CanadaNTSB CHI98GA025Accident · 2 fatalFinal reportAerospatiale AS350B · Frankfort, ILthe pilot in command misjudged the clearance with the terrain during a dark night maneuvering approach to a runway. A related factor was the dark night conditions.NTSB CHI98FA028Accident · 6 fatalField investigationFinal reportBeech BE 58 · New Berlin, ILA loss of engine power due to separation of the left engine's number 2 connecting rod as a result of fatigue failure. Also causal was the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Contributing to the accident was the…NTSB MIA98LA014Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Miami, FLloss of engine power for an undetermined reason(s), which resulted in a forced landing and subsequent encounter with rough water.NTSB LAX98LA026Accident · Minor injuriesLimited investigationFinal reportStriplin Lone Ranger Slvr CLD · Agua Dulce, CAFailure of the propeller system/drive assembly, and the pilot's failure to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection of the propeller system was a contributing factor.NTSB FTW98LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · San Antonio, TXinadequate service provided by the ground controller, by clearing the Boeing 727 to taxi after the Cessna 150 was cleared to taxi behind the 727, which led to a wake turbulence (jet exhaust) encounter and damage to the Cessna 150.NTSB FTW98LA036Accident · No injuriesLimited investigationFinal reportCessna 172F · Hurley, NMthe student pilot's failure to adequately compensate for the wind conditions. Factors included the gusty crosswind conditions and inadequate supervision of the student pilot's solo flight by his flight instructor.NTSB CHI98LA027Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Augusta, KSfailure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.NTSB CHI98LA026Accident · No injuriesLimited investigationFinal reportLearjet 35A · Sheboygan, WIa deer that ran in front of the airplane during the takeoff phase. A factor in this accident was the lack of an airport perimeter fence to prevent deer from getting onto the runway.NTSB NYC98LA022Accident · Serious injuriesLimited investigationFinal reportBeech B200 · Norfolk, VAThe passenger tripped for an undetermined reason.NTSB LAX98LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe student's inadvertent application of left brake during touchdown, and the instructor's inadequate supervision of the flight.NTSB FTW98LA035Accident · No injuriesLimited investigationFinal reportPilatus PC-6 · Lexington, TXthe pilot's selection of an unsuitable landing area. A factor relating to the accident was: the uneven terrain (with swales) at the edge of the landing area.NTSB FTW98LA033Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Counselor, NMthe pilot inadvertently allowing the helicopter to settle with power.NTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.NTSB LAX98FA031Accident · 4 fatalField investigationFinal reportCessna U206B · Markleeville, CAthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…NTSB FTW98LA034Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Roanoke, LAloss of engine power for an undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI98LA024Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's excessive pull-up and the flight instructor's inadequate supervision during a simulated engine failure after takeoff, resulting in a stall/mush onto the runway.NTSB ATL98FA008Accident · 3 fatalField investigationFinal reportCessna 402B · Tampa, FLThe pilot's failure to follow the landing checklist and extend the landing gear for landing, and his failure to maintain VMC during a go-around. Factors were: the pilot's diverted attention due to a non-stabilized instrument approach and his lack of recent…NTSB SEA98LA008Accident · 1 fatalLimited investigationFinal reportBeckham RV-4 · Scio, ORThe pilot-in-command's loss of control of the aircraft for undetermined reasons.NTSB NYC98LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Ocean City, NJThe pilot's failure to maintain sufficient altitude. Factors in the accident were the rain and fog.NTSB NYC98FA020Accident · 1 fatalField investigationFinal reportCessna 172E · Elkton, VAThe pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..NTSB LAX98LA021Accident · Serious injuriesLimited investigationFinal reportRevolution MINI-500 · Long Beach, CAloss of engine power and low rotor rpm for undeterminted reasons. The factory representative's recommendation to reduce the main rotor low pitch stop (from -1.8 degree to -0.5 degree) may have been a related factor.NTSB LAX98FA022Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA-300 · Castaic, CAThe pilot's failure to maintain control of the aircraft during an aerobatic maneuver.NTSB IAD98LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJthe pilot's improper flare during touchdown, which resulted in a hard landing and subsequent encounter with terrain.NTSB ANC98LA007Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB IAD98LA011Accident · No injuriesLimited investigationFinal reportSilvaire Luscombe 8B · Bluefield, WVThe pilot failed to maintain control of the airplane.NTSB FTW98LA032Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Boerne, TXthe pilot's failure to maintain directional control of the airplane during the aborted landing. Factors relating to the accident were: the pilot's improper recovery from a bounced landing, which resulted in a porpoise; his lack of total experience in the…NTSB FTW98FA031Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Hazen, ARThe pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the make and model of aircraft, the pilot's lack of total night flight experience, and the dark night conditions,NTSB NYC98LA023Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Farmingdale, NJThe certificated flight instructor's inadequate supervision and failure to maintain directional control.NTSB NYC98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Philadelphia, PAthe pilot's failure to check the elevator trim prior to takeoff, and his failure to retard the power in a timely manner after touchdown.NTSB NYC98FA018Accident · No injuriesField investigationFinal reportEnstrom F-28C · Fairview, PAinadequate maintenance, which led to detonation and a melted piston, and subsequent power loss.