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 CHI98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Janesville, WIthe pilot's failure to land the airplane at a proper touchdown point on the runway. A factor was the excessive rate of descent which developed on final approach.NTSB ANC98LA167Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Noorvik, AKA failure of the pilot to follow the aircraft checklist, and an inadvertent wheels up landing.NTSB ANC98FA152Accident · 1 fatalField investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, mountainous/hilly terrain features, rain, and fog.NTSB SEA98FA179Accident · 2 fatalField investigationFinal reportCessna 172M · Concrete, WAThe pilot's failure to maintain aircraft control for undetermined reasons. Night conditions were a factor.NTSB NYC98LA189Accident · No injuriesLimited investigationFinal reportCessna 172M · Teterboro, NJThe pilot's failure to maintain control of the airplane. Factors in this accident were the night light conditions, and pilot's lack of recent night flight experience.NTSB MIA98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Centre, ALThe failure of the pilot to attain the proper touchdown point and his delay in initiating a go-around during a high and fast approach. A factor was the ditch.NTSB CHI98LA339Accident · No injuriesLimited investigationFinal reportEnstrom 480 · Green Bay, WIthe pilot's failure to maintain adequate rotor rpm during a practice autorotation.NTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.NTSB ATL98LA126Accident · No injuriesLimited investigationFinal reportAeronca 65-TAC (L-3) · Dalton, GAThe pilots failure to maintain directional control of the airplane during landing. A factor was the pilot's lack of experience in the same make and model airplane.NTSB ATL98LA125Accident · Serious injuriesLimited investigationFinal reportHopkins Buckeye Industries Dream Machine 582 · Franklin, NCThe non-certificated pilot's inadequate judgement of the required climb rate, and his failure to attain clearance from obstacles.NTSB ANC98LA151Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to maintain adequate obstacle clearance.NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB SEA98LA177Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Spray, ORA partial loss of engine power, and the pilot's subsequent misjudgment of clearance with a transmission wire during a precautionary landing approach. The reason for the power loss was not determined; however, the pilot reported that it was not of a mechanical…NTSB NYC98LA187Accident · Minor injuriesLimited investigationFinal reportAnkenbruck Searey · Chippewa Lake, OHEncounter with swells from a boat wake. A factor in the accident was the pilot's inadequate initial training.NTSB LAX98RA310Accident · 3 fatalForeign investigationCessna 177 · Mt Cook, New ZealandNTSB LAX98LA293Accident · Serious injuriesLimited investigationFinal reportPZL-Bielsko SZD-59 · Truckee, CAThe failure of the pilot to maintain sufficient airspeed which resulted in a inadvertent stall/spin.NTSB FTW98FA399Accident · 1 fatalField investigationFinal reportCessna 172N · Montezuma Crk, UTThe pilot's attempted aerobatic maneuver and the subsequent inadvertent stall/spin. A factor was his intentional low altitude flight.NTSB SEA98LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lincoln City, ORThe pilot's inadequate remedial action to correct for a crosswind gust. The crosswind gust was a factor.NTSB IAD98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Oxford, CTThe pilot's inability to maintain directional control during the landing roll due to separation of the tailwheel spring assembly.NTSB FTW98LA398Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Watkins, COGusting winds which blew the aircraft inverted during taxi.NTSB FTW98LA395Accident · Serious injuriesLimited investigationFinal reportMaule M-5-235C · Mimbres, NMThe pilot's failure to maintain aircraft control while maneuvering. Factors were a low altitude turn into a crosswind and a high density altitude.NTSB ANC98LA149Accident · No injuriesLimited investigationFinal reportCessna 207 · Sleetmute, AKThe pilot's selection of unsuitable terrain for departure. A factor in the accident was a narrow runway.NTSB NYC98LA186Accident · No injuriesLimited investigationFinal reportCessna 180 · Lakeshore, MDFailures of the right float's nose wheel do to a preexisting fatigue crack.NTSB NYC98FA185Accident · 1 fatalField investigationFinal reportCessna 170A · Lagrangeville, NYThe pilot's failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall/spin.NTSB LAX98LA290Accident · No injuriesLimited investigationFinal reportWeber-Mustang II Diamond · Taft, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain proper runway alignment during the takeoff roll.NTSB FTW98LA397Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tahlequah, OKThe pilot's failure to maintain directional control of the aircraft during takeoff. A factor was the gusty wind conditions at the time of the accident.NTSB FTW98FA394Accident · 2 fatalField investigationFinal reportGrumman American AA-1B · Yoder, COThe pilot's loss of aircraft control due to not maintaining adequate airspeed and the subsequent inadvertent stall. Factors were the pilot's inadequate preflight and the engine's power failure due to fuel exhaustion.NTSB DCA99WA003Incident · No injuriesForeign investigationBoeing 767 · VietnamNTSB CHI98TA354Accident · No injuriesFinal reportBell 206B-3 · Hinkley, MNLoss of engine power due to failure of the engine governor.NTSB ATL98LA124Accident · No injuriesLimited investigationFinal reportCessna 150E · Bradenton, FLThe loss of engine power for undetermined reasons.NTSB ANC98LA148Accident · No injuriesLimited investigationFinal reportBeech 1900C · St. Mary'S, AKThe pilot's failure to follow the aircraft checklist, and an inadvertent wheels up landing. A factor was the pilot's distraction due to a malfunction of the flap systemNTSB SEA98LA176Accident · No injuriesLimited investigationFinal reportCessna 175 · Emmett, IDThe pilot's failure to ensure an adequate fuel supply for the flight, resulting in fuel exhaustion. A factor was a fence in the forced landing area.NTSB LAX98LA291Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Buckeye, AZthe pilot's delayed response in recovering from a bounced landing combined with his delayed decision to abort the landing. The pilot's inadequate compensation for tailwind conditions and inadvertently raising the flaps to 10 degrees were factors in this…NTSB FTW98LA396Accident · Serious injuriesLimited investigationFinal reportDempsey Skybolt TD8 · Dundee, TXHard landing due to the pilot's improper landing flare. Factor were the fuel exhaustion due to the pilot's failure to refuel, and his lack of familiarity with the airplane.NTSB FTW98LA391Accident · No injuriesLimited investigationFinal reportCessna 180F · Douglas, WYA collision with a deer during take-off.NTSB FTW98FA380Accident · No injuriesField investigationFinal reportBoeing 767-34AF · Houston, TXThe flight crew's decision to land with convective activity over the airport with a prevailing crosswind to a quartering tailwind, on an ungrooved, flooded runway, which resulted in hydroplaning and a loss of directional control. Factors contributing to the…NTSB DCA98WA087Incident · No injuriesForeign investigationBoeing 747-228F · Paris, FranceNTSB CHI98LA338Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Int'L Falls, MNinaccurate preflight planning which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. A factor associated with the accident was the tree which the airplane contacted during the forced landing.NTSB CHI98LA337Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL M18B · Tappen, NDthe pilot's improper preflight preparation resulting in the airplane exceeding the available airstrip distance during takeoff. A factor contributing to this accident was the swamp.NTSB ANC98LA147Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Big Lake, AKThe pilot's inadvertent stall/mush.NTSB ANC98LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was sunglare as the pilot landed into the sun.NTSB MIA98LA245Accident · Serious injuriesLimited investigationFinal reportWood Glasair SH2 · Holly Hill, SCThe pilot's failure to maintain airspeed, and his failure to perform a go-around. The pilot's misjudgment of speed and distance during the landing is a contributing factor.NTSB LAX98LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Los Banos, CAThe pilot's decision to takeoff in adverse wind conditions and inadequate compensation for the existing crosswind conditions, which resulted in a failure to maintain runway alignment.NTSB LAX98LA287Accident · No injuriesLimited investigationFinal reportCessna 170B · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional controlNTSB DCA98RA086Incident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaNTSB ANC98LA150Accident · No injuriesLimited investigationFinal reportCessna 207A · Hughes, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent stall. A factor in the accident was the presence of a tail wind.NTSB MIA98TA243Accident · No injuriesFinal reportBell BHT-47-G3B1 · Buckhead Ridge, FLThe failure of the pilot to adequately compensate for a tailwind condition on liftoff from the helipad.NTSB MIA98LA244Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Malone, FLa loss of engine power due to a chaffed ignition wires, resulting in a forced landing and subsequent impact with trees.NTSB LAX98LA289Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Tucson, AZFailure of the pilot to properly connect the aileron controls during reassembly of the glider, and, his inadequate preflight inspection of the glider.NTSB LAX98LA286Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Lihue, HIThe failure of the pilot to maintain directional control of the aircraft during the landing.