NTSB investigations, 1998
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 IAD99FA005Accident · 1 fatalField investigationFinal reportCessna R172K · Bowie, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.NTSB DEN99LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Jackson Hole, WYThe pilot's inability to maintain adequate airspeed which resulted in an inadvertent stall/mush. Factors contributing to the accident were the unfavorable weather condition, mountain wave and the high density altitude.NTSB DCA99WA004Incident · No injuriesForeign investigationMcDonnell Douglas DC-10-30 · Amsterdam, NetherlandsNTSB SEA99LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Buhl, IDThe pilot's failure to follow the aircraft's recommended balked landing procedure, resulting in a stall. Factors include the pilot's failure to maintain directional control during the landing flare, the pilot's lack of total experience, and insufficient…NTSB NYC99WA009Accident · 9 fatalForeign investigationCessna 402 · Sorstukken, NorwayNTSB NYC99FA007Accident · 2 fatalField investigationFinal reportCessna 172G · Bennington, VTThe pilot's VFR flight into IMC. Contributing factors were the pilot's lack of recent experience, mountainous/hilly terrain, and clouds.NTSB LAX99LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Apple Valley, CAThe pilot's inadvertent use of the aircraft's brakes while using the rudder pedals to maintain directional alignment during the takeoff roll.NTSB LAX99LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carson City, NVThe pilot's failure to verify the wind direction and speed, his selection of the wrong runway for the existing wind conditions, and, his inadequate compensation for those wind conditions.NTSB LAX99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Payson, AZthe pilot's failure to maintain runway alignment during a go-around.NTSB IAD99LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Pittstown, NJThe pilot's failure to obtain the proper touchdown point and his delay in executing a go-around. A factor in the accident was the tailwind.NTSB ATL99LA009Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT502B · Bainbridge, GAThe pilot's inadequate visual lookout which resulted in a collision with an irrigation unit located in the field.NTSB NYC99LA023Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe tug driver's failure to maintain a proper visual lookout.NTSB NYC99LA008Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Hilltown, PAThe pilot's misjudgment of altitude/distance which resulted in an in-flight collision which trees.NTSB LAX99LA008Accident · Minor injuriesLimited investigationFinal reportStearman E75 · Oakland, CAA loss of engine power due to the pilot's inadvertent entry into a negative 'g' condition, which induced a temporary interruption of the fuel supply.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB FTW99FA006Accident · 1 fatalField investigationFinal reportCessna 172M · Oklahoma City, OKSuicide.NTSB CHI99LA005Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Holstein, WIthe pilot-in-command's intentional low altitude maneuver and his ostentatious display. A factor was his allowing the airplane to enter an inadvertent stall.NTSB LAX99LA007Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Lost Hills, CAA loss of engine power due to fatigue failure of the number 4 cylinder articulating rod.NTSB IAD99LA007Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW99LA007Accident · 1 fatalLimited investigationFinal reportPainton Loehle Aviation 5151 · Osceola, ARThe pilot's failure to maintain aircraft control due to incapacitation as a result of hypertensive arteriosclerotic cardiovascular disease.NTSB DEN99LA010Accident · Serious injuriesLimited investigationFinal reportAerostar RXS8 · Albuquerque, NMThe high wind condition and the pilot's subsequent intentional hard touchdown. A factor was the small landing area that was available to the pilot.NTSB DEN99LA007Accident · No injuriesLimited investigationFinal reportCessna 210A · Provo, UTThe pilot's abrupt throttle control movement that caused the engine to flood, and his failure to follow emergency procedures contained in the Airplane Flight Manual. Factors were increasing the mixture control to full rich and switching the fuel pump to high…NTSB DEN99FA009Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Montrose, COThe pilot's improper inflight planning/decision. Factors were a reduction in the airplane's climb and turn capabilities, the aft c.g. limit being exceeded, and the pilot's lack of familiarity with the geographic area and his lack of experience in the airplane…NTSB CHI99LA006Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Oshkosh, NEthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the high winds, low altitude at which the pilot was maneuvering and the uneven terrain which the helicopter contacted.NTSB ATL99WA010Accident · 4 fatalForeign investigationCessna 172M · Freeport, BahamasNTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.NTSB ATL99LA007Accident · 2 fatalLimited investigationFinal reportW.S. Bowers, Jr. RV-4 · Apopka, FLThe pilot's failure to maintain airspeed while performing aerobatics which resulted in the lost of control and a stall/spin. A contributing factor was the low altitude at which the maneuver was performed.NTSB ATL99LA006Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Fayette, MSThe fuel filter contamination which resulted in the loss of engine power. The air leak in the fuel system was a factor.NTSB ATL99LA005Accident · No injuriesLimited investigationFinal reportCessna 188 · Patrick, SCThe failure of the number 2 piston for undetermined reasons.NTSB ANC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of a proper touchdown point. Factors associated with the accident were darkness, and the pilot's inadequate preflight planning.NTSB NYC99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-R200 · Caldwell, NJThe failure of both the normal and emergency brake systems.NTSB NYC99FA012Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Provincetown, MAThe failure of the pilot to follow the published instrument approach procedure, which resulted in inadvertent collision with water. Factors in the accident were the dark night and low ceiling.NTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA011Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 S 2 · Albuquerque, NMThe pilot's improper planning for his landing site approach which resulted in the balloon landing in close proximity to electrical transmission lines.NTSB CHI99LA007Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Superior, WIthe pilot not maintaining clearance with the terrain, and his improper decision to enter maneuvers too close to the terrain. Factors contributing to this accident were the aerobatic maneuvers, the trees and the berm.NTSB CHI99LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · Genesee, MIthe pilot's failure to maintain directional control and the subsequent failure to attain clearance with the trees during takeoff. Factors associated with the accident were the trees, dark night conditions, and fog which resulted in the lack of visual…NTSB CHI99FA003Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Howell, MIThe pilot's failure to maintain/exceed the Vmc airspeed during a go-around maneuver. Contributing factors were the shutting down of the left engine and the lack of recent experience in the type operation.NTSB NYC99WA006Incident · No injuriesForeign investigationBAC-Aerospatiale Concorde 102 · North Atlantic, CanadaNTSB NYC99LA005Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ravenna, OHThe pilot's improper decision to continue to operate the airplane with inoperative equipment which resulted in fuel exhaustion. Factors were the inoperative fuel quantity gauges, and the night conditions.NTSB FTW99LA005Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Ringling, OKThe pilot's failure to maintain obstacle clearance. A factor was the sun glare which impaired the pilot's vision.NTSB FTW99FA004Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Newellton, LAThe pilot's failure to maintain aircraft control during an inadvertent entry into adverse weather conditions. A related factor was the fog.NTSB DEN99LA006Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Alberquerque, NMThe passenger's failure to follow procedures/directives for a hard landing. A factor was the congested/confined landing area with power lines on both ends.NTSB DCA99RA002Incident · No injuriesForeign investigationDouglas MD-11 · Shannon, IrelandNTSB ANC99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Napaskiak, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. Factors in the accident were the pilot's inadequate planning/decision to continue a second takeoff following an engine surge and aborted takeoff, and unsuitable…NTSB MIA99FA005Accident · No injuriesField investigationFinal reportBoeing 727-224 · Miami, FLThe catastrophic failure of the 8th stage high pressure compressor disk from cadmium embrittlement as a result of improper adherence to the prescribed plating procedures and requirements by the company that last plated the disk. Contributing to the accident…NTSB FTW99LA011Accident · No injuriesLimited investigationFinal reportWilson Teenie TWO · Abilene, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB SEA99LA001Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315B · Big Sky, MTThe failure of the ground handlers (chokers) to follow procedures, and separation of the tail rotor system. Contributing factors were incorrect long line hook (size), jamming of the hook release, trees and gusty wind conditions.NTSB NYC99LA004Accident · Minor injuriesLimited investigationFinal reportEnstrom F280 · Bow, NHThe pilot's inadequate visual lookout and his failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tower. A factor in this accident was the gusty wind conditions.NTSB LAX99GA005Accident · 1 fatalFinal reportGrumman TS-2A · Banning, CAThe pilot misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, tailwind conditions, and turbulence in the area.NTSB LAX99FA006Accident · 2 fatalField investigationFinal reportRobinson R-22 · Lowerlake, CAThe flight instructor's failure to adequately supervise the conduct of the flight and the failure of the flying pilot to ensure that adequate ground clearance existed between the stinger/tail rotor and the ground during a deceleration while the aircraft was…