NTSB investigations, 1998
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\") = 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 MIA99LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150F · New Brockton, ALthe pilot's failure to perform fuel consumption calculations for the flight, resulting in a total power failure due to fuel exhaustion, and subsequent forced landing in soft terrain. Contributing factors in this accident were inadequate pre-flight planning…NTSB MIA99LA036Accident · No injuriesLimited investigationFinal reportCessna 172C · Tallahassee, FLan on ground collision with a horse.NTSB CHI99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-R200 · Eden Prairie, MNthe pilot misjudged the flare and did not maintain directional control during touchdown. A factor was the VASI lights.NTSB CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, OHThe pilot's disregard of the information provided by the fuel gauges, which resulted in fuel exhaustion. Factors in the accident included leaks in the fuel system, and the pilot's reliance on using timing alone to determine fuel consumption.NTSB NYC99LA027Accident · 1 fatalLimited investigationFinal reportBeech C35 · London, KYThe pilot's inadequate start procedure in which he fail to secure the aircraft from movement during an attempt to handprop the engine.NTSB LAX99WA026Accident · No injuriesForeign investigationBoeing 767-300ER · Las Vegas, NVNTSB LAX99LA041Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Vacaville, CAThe pilot's inadequate compensation for the existing variable wind conditions and his failure to maintain directional control.NTSB LAX99LA040Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Oroville, CAThe pilot's decision to attempt readjustment of the rudder pedal in-flight.NTSB IAD99LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Akron, OHThe pilot's inadequate preflight which resulted in a takeoff with the fuel cap unsecured.NTSB FTW99LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Greenville, TXThe partial loss of engine power due to a blocked muffler exhaust pipe/manifold as a result of a loose internal baffle. Factors were the improper maintenance by other maintenance personnel and the lack of suitable terrain for the forced landing.NTSB CHI99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hancock, MIthe pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…NTSB ATL99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aiken, SCThe pilot's failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.NTSB ATL99LA023Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Locust Grove, GALoss of engine power due to a gear train failure in the accessory gearbox for undetermined reasons. A factor was the rough and uneven terrain.NTSB FTW99LA034Accident · Serious injuriesLimited investigationFinal reportStanton Staros SA 260 · Marion, TXThe fuel leak for an undetermined reason which resulted in an in-flight fire.NTSB FTW99FA033Accident · 2 fatalField investigationFinal reportCessna 172N · Bacliff, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions and his inability to maintain adequate altitude/clearance from the wire. Contributing to the accident were the fog, low ceilings and his lack of instrument time.NTSB CHI99LA037Accident · Serious injuriesLimited investigationFinal reportBeech BE-55 · Crystal, MNthe pilot failed to maintain the proper glidepath. A factor was the sunglare.NTSB CHI99LA035Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Alliance, NEWas the late flare and stall by the student pilot and improper remedial actions by the student pilot.NTSB CHI99LA033Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Salem, ILThe simulated emergency procedure by the pilot-in-command. Additional causes were the directional control not obtained/maintained by the pilot-in-command and the inadequate supervision by the Federal Aviation Administration (FAA) Inspector. A contributing…NTSB LAX99LA039Accident · No injuriesLimited investigationFinal reportVarga 2150A · Chandler, AZFuel exhaustion due to the pilot's failure to perform an adequate preflight of the aircraft to ensure that adequate fuel was available for the flight.NTSB FTW99LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Fayetteville, ARThe pilot's inadequate compensation for the wind conditions resulting in a loss of directional control. A factor was the shifting and gusty wind conditions.NTSB DEN99LA021Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Aurora, COThe pilot's failure to maintain directional control. Factors were the gusty crosswind and terrain.NTSB CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.NTSB CHI99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Iowa Falls, IAthe pilot's improper preflight planning and preparation, and his not refueling the airplane. Factors were fuel exhaustion and the fence.NTSB LAX99LA054Accident · No injuriesLimited investigationFinal reportWilliams Hurrican HP · Corona, CAThe seizure of the engine due to a cylinder/piston overheat condition for undetermined reasons.NTSB LAX99LA042Accident · No injuriesLimited investigationFinal reportMartin Stoddard Hamilton II · Georgetown, CAThe pilot's improper flare. Also causal was the flight instructor's inadequate supervision.NTSB LAX99FA038Accident · 1 fatalField investigationFinal reportCessna T210L · Oakland, CAThe pilot-in-command's inadequate fuel management which led to fuel starvation and subsequent loss of engine power. Also causal was the pilot's failure to maintain adequate altitude and his ostentatious display.NTSB LAX99FA036Accident · 2 fatalField investigationFinal reportCessna 172P · Scottsdale, AZthe failure of the solo student pilot in the other aircraft to acquire and maintain separation from this aircraft, which was departing the airport traffic pattern and had been issued as traffic by the local controller. Also causal was the failure of the pilot…NTSB IAD99FA020Accident · 1 fatalField investigationFinal reportBurgess RV-6 · Edgewater, MDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's unfamiliarity with the geographic location and dark night conditions.NTSB NYC99FA026Accident · 1 fatalField investigationFinal reportCessna 414A · Mattapoisett, MAThe pilot's failure to maintain control of the airplane after an undetermined failure of the airplane's attitude indicator. A factor in this accident was fog.NTSB MIA99LA035Accident · No injuriesLimited investigationFinal reportCessna 182C · St. Petersburg, FLthe pilot misjudged the flare, resulting in a hard land and subsequent damage to the airplane.NTSB LAX99LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B · Camarillo, CAThe pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision.NTSB FTW99LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA32-300 · New Iberia, LAThe mechanic's failure to properly torque the connecting rod's bolt and nut during engine overhaul. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tower, MNthe student pilot's failure to maintain directional control of the airplane after landing. Factors contributing to this accident were the icy runway and the snowbank.NTSB LAX99LA035Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Upland, CALoss of engine power due to water contaminated fuel and the pilot's inadequate preflight inspection of the airplane. A factor was the failure of the owner/pilot to properly maintain the airplane.NTSB LAX99LA034Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orinda, CAA loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.NTSB IAD99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Melfa, VAThe loss of engine power for undetermined reasons.NTSB FTW99LA031Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Bunkie, LAThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA030Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alexandria, LAThe pilot's failure to maintain clearance with the water during the turnaround maneuver. A factor was the haze over the river.NTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.NTSB ATL99FA021Accident · No injuriesField investigationFinal reportBeech BE-55B · Hampton, GAThe pilot's failure to use the landing checklist that resulted in the wheels-up landing.NTSB FTW99LA027Accident · Minor injuriesLimited investigationFinal reportMooney M20J · San Angelo, TXThe total loss of engine power due to the magneto failure resulting from oil contamination when the bearing plate retainer screw fractured due to improper manufacturing. Factors were the lack of suitable terrain for the forced landing, and the dark night…NTSB ATL99FA020Accident · Serious injuriesField investigationFinal reportCessna 172N · Concord, NCThe pilot's improper in-flight decision and his failure to maintain clearance during approach that resulted in collision with utility lines. Related factors were dark night, trees and low ceilings.NTSB SEA99FA015Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Ferndale, WAThe pilot's improper decision to attempt to reach his final destination after a partial loss of engine power, instead of making a precautionary landing at one of the airports he overflew along his route. Factors include an inadequate preflight, a fuel filter…NTSB LAX99LA033Accident · Serious injuriesLimited investigationFinal reportOld Hen Crow G1 · Tehachapi, CAThe failure of the pilot to maintain sufficient airspeed, which resulted in the aircraft entering a stall/mush flight condition that continued to impact. A factor in the accident was the pilot's lack of familiarity with the type of aircraft.NTSB IAD99LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Essex, MDA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and dark night conditions.NTSB ATL99FA019Accident · 1 fatalField investigationFinal reportCessna 182P · Santee, SCThe pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.NTSB MIA99FA034Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Olive Branch, MSThe pilot's failure to follow IFR procedures when he descended below the published minimum descent altitude.NTSB IAD99LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJthe student's pilot's inadequate climb and his failure to maintain adequate altitude and clearance. A related factor was the wind gusts.NTSB FTW99LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Matagorda 713The pilot's loss of control due to his failure to untie ground straps. A factor was his inadequate preflight inspection.