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 ATL99LA030Accident · No injuriesLimited investigationFinal reportMichael L. Thibault RV-4 · Okeechobee, FLThe pilot's failure to use carburetor heat that resulted in the total loss of engine power. Factors were conditions favorable for the formation of carburetor ice.NTSB LAX99LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Victorville, CAFuel starvation caused by the pilot's failure to select a tank containing fuel.NTSB DCA99WA020Accident · No injuriesForeign investigationA330 · Manilla, PhilippinesNTSB DCA99WA017Accident · 2 fatalForeign investigationBeech Kingair 300 · Istanbul, TürkiyeNTSB CHI99FA047Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Waterford, MIthe pilot's descent below the decision height for the instrument approach.NTSB ATL99LA029Accident · No injuriesLimited investigationFinal reportCessna 150B · Adjuntas, PRThe loss of engine power due to the restricted movement of the intake and exhaust valves on number 3 cylinder.NTSB ATL99LA028Accident · Minor injuriesLimited investigationFinal reportSid Champion Jurca MJ-5 · Madison, MSA loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB NYC99FA033Accident · 1 fatalField investigationFinal reportGulfstream American AA-1 · Brooklyn, CTThe student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.NTSB LAX99TA043Accident · No injuriesFinal reportPiper PA-18-150 · Imperial, CAThe pilot's inadequate compensation for the gusty wind conditions while taxiing from landing.NTSB LAX99LA049Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Winterhaven, CAThe failure of the pilot to maintain rotor rpm. A factor was his attempt to take off over gross weight.NTSB DEN99FA024Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta II · Deming, NMThe pilot's failure to maintain clearance of the transmission wire. Factors were the transmission wire, and the glaring sunlight condition.NTSB CHI99LA048Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burlington, WICarburetor ice, the pilot's inadequate pre-flight planning/preparation resulting in his flight into poor weather conditions, and the pilot's improper use of carburetor heat. Factors contributing to this accident were the carburetor icing conditions, the…NTSB ANC99LA015Accident · No injuriesLimited investigationFinal reportStinson 10A · Nondalton, AKThe pilot's continued operation of the airplane with known deficiencies, a failure of company maintenance personnel to replace an inoperative fuel gauge, and subsequent fuel exhaustion. Factors in the accident were siphoning of fuel from the right wing fuel…NTSB NYC99FA032Accident · Minor injuriesField investigationFinal reportEurocopter EC-135-P1 · Newark, NJthe pilot's failure to maintain proper rotor rpm and his improper in flight decision to enter autorotation due to his lack of knowledge of the power plant controls. Factors in the accident were the night conditions and the pilot's improper decision to fly…NTSB FTW99LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Springdale, ARThe pilot's improper recovery from a bounced landing resulting in a ground loop. A factor was the pilot's improper landing flare.NTSB CHI99LA046Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Naponee, NEthe pilot's failure to identify the wires prior to spraying the field and the low altitude at which the pilot was flying. A factor was the wires which the airplane contacted.NTSB CHI99LA045Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Ankeny, IAthe elevator control system jammed for undetermined reasons.NTSB ATL99LA027Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, NCThe failure of the #2 exhaust valve that resulted in the total loss of engine power. A factor is the lack of suitable emergency landing terrain.NTSB ANC99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Point Lay, AKFailure of the pilot to maintain a proper glidepath. Factors associated with this accident were the airport not having a VASI system installed, and the lack of visual perception for the pilot.NTSB MIA99LA040Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Star, NCThe failure of the pilot to use proper short-field landing procedure, resulting in an extended flare and touchdown by the nose wheel and right main wheel simultaneously, and the subsequent loss of directional control and collision with trees.NTSB FTW99LA042Accident · Serious injuriesLimited investigationFinal reportHoliman Pietenpol Aircamper · England, ARThe pilot's failure to maintain clearance with the powerline while maneuvering.NTSB FTW99FA041Accident · 1 fatalField investigationFinal reportCessna 501 · Umpire, ARThe pilot's in flight loss of control for undetermined reasons.NTSB MIA99LA041Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fort Gains, GAa power loss due to internal damage to the second- and third- stage turbine rotor blades, due to thermal heat, rendering the engine incapable of producing full power, resulting in a forced landing, and subsequent impact with the terrain.NTSB MIA99LA039Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Fort Lauderdale, FLan abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.NTSB MIA99FA038Accident · No injuriesField investigationFinal reportBoeing 747-259B · Miami, FLa fire that started under the fuel truck's cab from an undetermined fuel leak, resulting in fire damage to the airplane.NTSB FTW99LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot's loss of directional control due to improper use of the rudder. A factor was the hilly terrain beyond the departure end of the runway.NTSB CHI99LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mason, MIthe pilot's inattention to fuel management in that he failed to switch fuel tanks in a timely manner which resulted in fuel starvation. A factor related to the accident was the low altitude at which the loss of engine power occurred.NTSB SEA99LA016Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-900 · Idaho City, IDThe pilot-in-command's not obtaining/maintaining clearance with the unmarked transmission lines. Contributing factors were environmental (dusk) conditions, the transmission lines, and both the pilot-in-command and the ground personnel not identifying the…NTSB NYC99LA029Accident · Minor injuriesLimited investigationFinal reportBoeing 747-400 · Jamaica, NYThe first officer misjudged the clearance between the right wing and the crane. Factors included the subcontractor's unauthorized placement of the crane in the taxiway safety area and insufficient oversight of the subcontractor's operations.NTSB DEN99LA022Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Carrizozo, NMThe loss of engine power for undetermined reasons.NTSB MIA99LA045Accident · Minor injuriesLimited investigationFinal reportQuicksilver MXL-2 · Humacao, PRThe pilot's use of a synthetic oil that is not recommended by the engine manufacturer when premixing his two cycle gasoline/oil fuel mixture, resulting is a total loss of engine power due to decreased lubricating properties, and the subsequent forced landing…NTSB IAD99FA023Accident · 1 fatalField investigationFinal reportArmbruster MINI-500 · Midland, VAthe improper repair of the engine following a previous engine seizure which resulted in the loss of engine power over unsuitable terrain.NTSB DCA99IA023Incident · No injuriesIncident investigationFinal reportBoeing 757 · Washington, DCUndetermined.NTSB CHI99FA042Accident · 2 fatalField investigationFinal reportCessna 172F · Coleman, WIpilot's failure to maintain clearance from the trees and his intentional flight into IMC conditions. Factors contributing to this accident were the pilot's lack of instrument certification, his becoming lost in the poor weather, his inadequate preparation for…NTSB ATL99LA026Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · La Tortue, HaitiInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the terrain ( water).NTSB NYC99LA030Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Gasport, NYA collision with a deer while landing.NTSB LAX99LA045Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Inyokern, CAThe failure of the pilot to maintain control of the aircraft while landing.NTSB IAD99LA022Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Easton, MDThe failure of both the pilot-in-command (CFI) and dual student of the other aircraft (Pitts) to maintain adequate visual lookout.NTSB FTW99LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Braithwaite, LAThe pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.NTSB FTW99FA038Accident · 1 fatalField investigationFinal reportBlanton RAF 2000 · The Colony, TXThe pilot's failure to maintain control of the gyroplane during cruise flight. A factor was the gusty wind condition.NTSB DCA99WA014Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomNTSB ATL99LA024Accident · Serious injuriesLimited investigationFinal reportBeech 33-F33A · Fernandina Bch, FLThe Pilot's failure to maintain flying airspeed that resulted in a loss of control and an inadvertent stall. Factors were several electrical system component malfunction.NTSB SEA99LA017Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Jardine, MTThe pilot-in-command's failure to maintain adequate clearance with trees and terrain. Contributing factors were unfavorable winds, mountainous terrain and trees.NTSB FTW99LA045Accident · No injuriesLimited investigationFinal reportLockheed L-1329 · Austin, TXThe steering actuator fatigue failure resulting from inadequate procedure documentation for the manufacturing process.NTSB FTW99LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Stuttgart, ARThe separation of the left main landing gear bolt.NTSB DCA99WA013Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · SingaporeNTSB DCA99WA011Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Jakarta, IndonesiaNTSB CHI99LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · East St. Louis, ILThe student pilot's failure to maintain directional control.NTSB CHI99LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Brainerd, MNThe visual lookout not obtained/maintained by the pilot of the other aircraft. Contributing factors were the unicom frequency not selected and the traffic advisory not issued by the pilot of the other aircraft. An additional factor was the aircraft moving on…NTSB NYC99WA028Accident · No injuriesForeign investigationCessna 208B · Hamilton, Canada