NTSB investigations, 1997
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI97LA253Accident · No injuriesLimited investigationFinal reportPiper PA-28-121 · Glencoe, MNfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve and subsequent collision with trees. Factors associated with the accident were: the crosswind, and proximity of trees.NTSB ATL97LA119Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe loss of control of the airplane due to the pilot's improperly planned approach and failure to maintain adequate airspeed.NTSB ATL97LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Rockhill, SCThe pilot's failure to plan and have adequate fuel for the flight.NTSB DCA97MA059Accident · 5 fatalClass 1 · MajorFinal reportDouglas DC-8-61 · Miami, FLThe airplane being misloaded to produce a more aft center of gravity and a correspondingly incorrect stabilizer trim setting that precipitated an extreme pitch-up at rotation, was (1) the failure of Fine Air to exercise operational control over the cargo…NTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.NTSB NYC97LA161Accident · No injuriesLimited investigationFinal reportCessna A150L · Waynesburg, PAthe pilot's inadequate preflight by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion during takeoff.NTSB MIA97LA230Accident · No injuriesLimited investigationFinal reportCessna R172E · Mary Esther, FLThe loss of engine power for undetermined reasons.NTSB LAX97LA273Accident · No injuriesLimited investigationFinal reportCessna 140 · Pacoima, CAThe pilot's failure to maintain directional control of the aircraft during landing.NTSB IAD97LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Willimantic, CTThe student pilot misunderstood the flight instructor's instructions and reduced the engine power to idle, and the Certificated Flight Instructor's delayed remedial action.NTSB DCA97MA058Accident · 228 fatalClass 1 · MajorFinal reportBoeing 747-300 · Nimitz Hillthe captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…NTSB CHI97LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Keokuk, IAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise, failure (collapse) of the nose gear, and a subsequent nose over.NTSB ATL97LA112Accident · No injuriesLimited investigationFinal reportCessna 310K · Bainbridge, GAThe pilot's failure to properly perform the soft landing procedure, leading to a hard landing.NTSB SEA97LA186Accident · No injuriesLimited investigationFinal reportCessna 172M · Langley, WAA failed exhaust valve. Factors were tailwind and excessive airspeed during the ensuing forced landing. .NTSB MIA97LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Cadaretta, MSa hard landing resulting in the airplane departing the runway and impacting with a tree.NTSB MIA97LA227Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Tullahoma, TNthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation, a forced landing, and impact with a tree.NTSB LAX97FA272Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Hesperia, CAfailure of the pilot to see-and-avoid high voltage power lines, while coping with a lack of engine power during a go-around in a high density altitude condition. Factors relating to the accident were: high density altitude that resulted in a normal reduction…NTSB FTW97FA299Accident · 2 fatalField investigationFinal reportBeech 58P · Colorado Spring, COfailure of the pilot to follow IFR procedures; and his failure to maintain proper altitude, while executing a missed approach from an attempted ILS approach. Related factors included: low ceiling, rain, fog, the pilot's overconfidence in his personal ability,…NTSB CHI97LA247Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Hampshire, ILthe pilot's failure to maintain directional control of the airplane during landing, and his excessive use of brakes, which resulted in a nose over. Factors relating to the accident were: the crosswind condition, and the pilot's lack of experience in the make…NTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…NTSB ANC97LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Farewell, AKthe pilot's failure to maintain adequate control of the airplane resulting in an inadvertent stall/mush at low altitude. Factors to the accident were the pilot's low altitude flight maneuver and the gusty winds.NTSB SEA97LA182Accident · 1 fatalLimited investigationFinal reportCessna 140 · Vancouver, WAAircraft control was not maintained. Continued operation with known deficiencies in equipment and movement restrictions to an exhaust valve were factors.NTSB NYC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Ashland, OHThe pilot's improper fuel management which resulted in fuel exhaustion and loss of engine power.NTSB NYC97FA159Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Danbury, CTThe pilot's failure to takeoff with the fuel selector in the full on position, which resulted in fuel starvation. Also causal was the pilot's improper in-flight decision to attempt a 180 degree turn back to the runway, which resulted in the inadvertent…NTSB LAX97LA271Accident · No injuriesLimited investigationFinal reportMiller S-1 · Cottonwood, AZThe inadequate strength and braking capability of the landing gear and wheel brakes, and the builder's attempt to adapt motorcycle parts to an aircraft application. A factor in this accident was the pilot's lack of familiarity with this experimental aircraft.NTSB FTW97LA294Accident · No injuriesLimited investigationFinal reportBeech C24R · Pollock, LAThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel selector. Factors were the pilot's failure to use the checklist and the lack of suitable terrain for the forced landing.NTSB CHI97LA249Accident · No injuriesLimited investigationFinal reportBeech A36 · Chesterfield, MOthe pilot's failure to maintain proper alignment on the taxiway. Factors associated with the accident were the fence post, and the sunglare, which hindered the pilot's ability to see the fence post.NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.NTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.NTSB NYC97LA158Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Quinton, VAThe pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.NTSB NYC97LA157Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Easton, MDan inadequate weld repair, which resulted in insufficient structural strength of the left main gear.NTSB MIA97WA226Accident · 1 fatalForeign investigationBoeing 757-200 · Lima, PeruNTSB FTW97LA298Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Castle Rock, COA partial loss of engine power due to a cylinder exhaust valve jammed in the open position from excessive carbon deposits. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW97LA297Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Creede, COThe pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.NTSB CHI97LA251Accident · Serious injuriesLimited investigationFinal reportLarsen T-BIRD II · Oshkosh, WIthe pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.NTSB CHI97LA243Accident · No injuriesLimited investigationFinal reportCessna 182P · Oshkosh, WIwake turbulence from another airplane encountered at an altitude which precluded regaining control of the airplane by the pilot.NTSB CHI97LA235Accident · No injuriesLimited investigationFinal reportCessna A188A · Norfolk, NEthe pilot's improper in-flight planning/decision, and failure or inability to control the airplane after encountering wake turbulence at low altitude during an aerial application maneuver. A related factor was the low altitude of the airplane when the wake…NTSB ANC97LA116Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Ashton, AKThe pilot's selection of unsuitable terrain. Factors associated with the accident were the tailwind and soft terrain.NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.NTSB MIA97LA225Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe improper rebuild/remanufacture of the fuel line (obstructed at both ends) that runs between the carburetor and sediment bowl by an unknown person. This resulted in a loss of engine power due to fuel starvation, forced landing to non-suitable terrain, and…NTSB IAD97LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAInadequate compensation for wind conditions by the pilot. A related factor was the crosswind.NTSB FTW97LA301Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Terlingua, TXThe inadvertent stall by the pilot-in-command. A factor was the sudden wind shift.NTSB FTW97LA296Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Harrison, ARThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Fond Du Lac, WIthe pilot's improper use of the throttle control friction lock, and his inadequate remedial action. Related factors were his lack of experience in type of aircraft, the pilot's habit interference, and the presence of parked (standing) aircraft.NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB CHI97LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Lee'S Summit, MOthe pilot's inadequate preflight planning/preparation, and his failure to ensure that the airplane remained clear of obstrictions (trees). Factors associated with the accident were: the short runway/takeoff area, and the proximity of trees.NTSB CHI97LA234Accident · Minor injuriesLimited investigationFinal reportRutan Defiant · Alma, MIthe pilot did not perform an adequate preflight check and he did not perform the takeoff checklist. Factors included the pilot's inadequate design of the safety latch and the canopy inadvertently deploying.NTSB ANC97LA114Accident · No injuriesLimited investigationFinal reportCessna 170B · Juneau, AKThe pilot's selection of an unsuitable off-airport site for takeoff, and his premature lift-off.NTSB NYC97LA156Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WVThe student pilot's improper recovery from a bounced landing.