NTSB investigations, 1998
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\") = 1998 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") = 1998 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 FTW98FA354Accident · 1 fatalField investigationFinal reportMooney M20J · Centennial, WYThe pilot's disregard of information provided in weather briefs, and his flight into known adverse weather in mountainous terrain which resulted in an in-flight collision with a mountain. Factors were rain and low ceiling/visibility.NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.NTSB CHI98FA344Accident · 2 fatalField investigationFinal reportCessna A185F · Phillips, WIThe pilot's failure to maintain adequate altitude/clearance with trees. Contributing factors were fog, rain showers, and the trees.NTSB CHI98FA299Accident · 2 fatalField investigationFinal reportCessna 140 · St. Joseph, MOthe pilot not maintaining a proper final approach glide path to avoid an encounter with wake turbulence. A factor in this accident was the pilot not being able to control the airplane after its encounter with wake turbulence.NTSB SEA98FA161Accident · 1 fatalField investigationFinal reportCessna 177 · Red Lodge, MTThe pilot's failure to maintain adequate altitude over, or clearance with, mountainous terrain during night visual flight rules flight. Factors included night lighting conditions and mountainous terrain.NTSB MIA98LA217Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA loss of engine power due to undetermined reasons, resulting in an inadvertent stall at too low an altitude to allow recovery.NTSB LAX98LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willits, CAThe pilot's selection of an inadequate landing area and failure to maintain clearance from obstacles during the landing roll.NTSB LAX98LA255Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Nelson, CAThe pilot's failure to maintain an adequate ground clearance altitude while applying chemicals to a rice field.NTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB FTW98LA343Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Watkins, COThe pilot's loss of control during taxi due to excessive taxi speed.NTSB CHI98LA298Accident · No injuriesLimited investigationFinal reportPiper PA28-R-200 · W. Frankfort, INThe failure of the fuel mixture control linkage, and inadequate inspections by maintenance personnel.NTSB SEA98TA156Accident · Minor injuriesFinal reportSchweizer SGS 2-33 · Ephrata, WAThe student pilot-in-command's failure to maintain control of the aircraft during the landing. Contributing factors were panic and inadequate initial training.NTSB NYC98LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Hackettstown, NJThe pilot's failure to use the airplane's takeoff performance data, and his failure to obtain the proper climb airspeed.NTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.NTSB MIA98LA216Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Tuskegee, ALThe pilot's failure to attain adequate airspeed, and his failure to abort the takeoff.NTSB IAD98FA086Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Stevensville, MDThe pilot-in-command's failure to maintain aircraft control while buzzing a building.NTSB CHI98LA295Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-6B · Quincy, ILthe right main landing gear collapsed for undetermined reasons.NTSB CHI98LA294Accident · Minor injuriesLimited investigationFinal reportPiper 20 · Andover, KSa loss of engine power for undetermined reasons. A factor associated with the accident were the trees which the airplane contacted and the low altitude at which the loss of power occurred.NTSB CHI98LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Laporte, INwas the student pilot s inadequate compensation for the wind conditions he encountered during the landing phase. A factor in this accident was the pilot s lack of total experience.NTSB CHI98FA296Accident · 1 fatalField investigationFinal reportCessna 340A · Chicago, ILthe pilot's improper use of the throttle in not using full power for takeoff, the pilot's failure to use proper aborted takeoff procedures, and the inadvertant stall/mush. A factor associated with the accident was inadequate preflight/planning by the pilot.NTSB CHI98FA288Accident · 1 fatalField investigationFinal reportHispano Aviacion A10B-37 · Oshkosh, WIthe pilot's failure to maintain adequate altitude which resulted in in-flight collision with trees and subsequent compressor stall for undetermined reasons.NTSB NYC98LA158Accident · Minor injuriesLimited investigationFinal reportCessna 175 · East Canton, OHThe pilot's failure to maintain direction control of the airplane.NTSB MIA98LA218Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Pensacola, FLThe pilot's failure to maintain a proper sink rate during an emergency landing resulting in impact with trees and subsequent stall and impact with the terrain.NTSB LAX98LA253Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Lincoln, CAThe pilot of the other aircraft's inadequate visual lookoutNTSB IAD98LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAFailure to maintain directional control during the takeoff roll. A related factor was wind gusts.NTSB IAD98LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Lebanon, OHThe pilot's delay in aborting the landing, which resulted in inadequate obstacle (car) clearance during initial takeoff climb. A contributing factor is the pilot's decision to perform a tailwind landing.NTSB CHI98LA297Accident · No injuriesLimited investigationFinal reportCessna 180 · Oshkosh, WIthe pilot of the other airplane did not maintain proper clearance.NTSB CHI98FA287Accident · 1 fatalField investigationFinal reportNavion A · Coloma, WIFailure of the pilot to maintain proper altitude, and his failure to maintain adequate visual lookout to see and avoid obstructions. The transmission wire was a contributing factor.NTSB ANC98LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cantwell, AKThe pilot's intentional continued VFR flight into IMC. Factors were the scattered to broken clouds, and the mountainous terrain.NTSB SEA98LA154Accident · 1 fatalLimited investigationFinal reportCessna 172 · Baker City, ORThe pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.NTSB NYC98LA159Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Point Of Woods, NYImproper maintenance which resulted in the installation of an incorrect venturi and the subsequent loss of engine power.NTSB MIA98TA215Accident · No injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for an undetermined reason, resulting in a forced landing, and an in-flight collision with a ditch. A factor in this accident was a high density altitude.NTSB FTW98FA340Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Seminole, TXThe pilot's failure to maintain aircraft control.NTSB FTW98FA338Accident · 3 fatalField investigationFinal reportCessna 210M · Leesville, LAThe pilot's failure to establish a climb during a night go-around. Factors were the lack of visual cues available to the pilot and the dark night illumination.NTSB DCA98WA076Incident · No injuriesForeign investigationBoeing 747-400 · Cologne, GermanyNTSB CHI98LA293Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Salina, KSinadequate maintenance which failed to detect corrosion in the fuel injector system and the fuel pump. Factors related to the accident were the low altitude and airspeed at which the loss of engine power occurred.NTSB CHI98LA292Accident · No injuriesLimited investigationFinal reportBell M74L · Grand Forks, NDThe worn rotor clutch shoes, and subsequent loss of main rotor rpm.NTSB CHI98LA290Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mentha, MIthe pilot's improper inflight decision to land the airplane on the gravel covered road with an uneven surface that had corn growing next to its edge. A factor in this accident was the pilot selecting an unsuitable landing area.NTSB CHI98FA286Accident · Minor injuriesField investigationFinal reportMonocoupe 70 · New Holstein, WIThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB ANC98LA114Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Anchorage, AKThe pilot's failure to maintain directional control during landing, and the resulting overload fracture of the tailwheel fork assembly.NTSB ANC98LA113Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kodiak, AKThe pilot's inadequate weather evaluation and compensation for wind conditions. Factors associated with the accident are wind gusts, a sudden windshift to a tailwind, the pilot's failure to abort the takeoff, and an inadvertent stall/mush.NTSB SEA98IA153Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135 · Moses Lake, WAAircraft control was not maintained.NTSB LAX98LA249Accident · No injuriesLimited investigationFinal reportBell 222B · Tranquility, CAThe pilot's delayed initiation of a go-around when the severity of the dust condition first became apparent. Contributing factors were dark night conditions and the obscuration from the dust.NTSB DCA98RA075Accident · 15 fatalForeign investigationBeech 1900D · Lorient, FranceNTSB CHI98LA291Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Plainview, MNThe pilot's not achieving the proper descent rate prior to touchdown. A factor related to the accident was fuel starvation due to a low fuel level.NTSB ANC98LA112Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate procedures/directives when he allowed a passenger to exit the cabin area while the propeller was still turning, and the passenger's failure to follow the pilot's instructions to stay away from the propeller. A factor associated with the…NTSB SEA98TA152Accident · Minor injuriesFinal reportCessna TU206G · Burns, ORFatigue failure of the crankshaft.NTSB MIA98LA214Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Monticello, MSthe pilot's failure to maintain control of the helicopter while maneuvering resulting in the main rotor blades striking the ground.NTSB LAX98LA250Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Corona, CAThe loss of engine power due to a partially closed fuel shutoff valve as a result of improper maintenance installation.NTSB LAX98LA247Accident · No injuriesLimited investigationFinal reportCessna 150K · Yorba Linda, CAAn oil starvation failure of the engine due to the mechanic's inadequate maintenance installation and quality control procedures, which resulted in a shop rag being inadvertently left inside the accessory case when the starter was changed 7 hours prior to the…