NTSB investigations, 1999
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\") = 1999 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") = 1999 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 SEA00LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Malheur City, ORThe pilot's excessive descent rate during an attempted precautionary landing. Factors include the pilot's intentional operation of his aircraft with a known electrical system deficiency, a malfunction of the electrical system while in flight, the pilot's…NTSB NYC00LA033Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Fayetteville, WVThe pilot's decision to continue the landing attempt too far down the runway. A factor was the pilot's self-induced pressure to land the airplane, due to the sickness of the front seat passenger.NTSB LAX00LA035Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Van Nuys, CAThe pilot's encounter with unknown and unanticipated wake turbulence from a heavy transport aircraft, which was landing at another airport. A factor in the accident was the tower controller's failure to repeat a previously broadcast wake turbulence cautionary…NTSB LAX00LA033Accident · Serious injuriesLimited investigationFinal reportRaven RX-7 · Phoenix, AZThe pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.NTSB CHI00LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-34 · East Lynne, MOinadequate airspeed and a subsequent stall. Factors associated with the accident were the tailwind, the pilot's misjudgment of the wind condition, and poor inflight planning.NTSB ATL00LA014Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ridgeland, SCThe pilot's failure to obtain/maintain adequate airspeed during the takeoff/initial climb which resulted in an inadvertent stall and subsequent collision with terrain.NTSB IAD00LA005Accident · No injuriesLimited investigationFinal reportAnkenbruck SEA Hawk · Somerset, PAThe pilot's improper preflight which resulted in a loss of power due to contaminated fuel, and the pilot's failure to maintain aircraft control after the loss of power. A factor in the accident was fuel contamination.NTSB DEN00LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Rawlins, WYThe pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB DCA00WA011Incident · No injuriesForeign investigationBritish Aerospace BAe-146 · Malmo, SwedenNTSB CHI00FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 175 · MIundetermined.NTSB CHI00FA027Accident · 3 fatalField investigationFinal reportBeech 200 · Chicago, ILOn ground collision with the lake for undetermined reasons.NTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.NTSB SEA00IA019Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Portland, ORArcing in the electrical system wiring for undetermined reasons.NTSB LAX00LA032Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, CAThe pilot's failure to maintain directional control of the airplane during the touch-and-go takeoff.NTSB FTW00LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rose Hill, TXThe pilot's failure to maintain directional control during takeoff roll, which resulted in an inadvertent ground loop.NTSB CHI00LA028Accident · Serious injuriesLimited investigationFinal reportShaffer Evans Volksplane · Stanley, NDrefueling not performed by the non-rated pilot and the lack of total experience of the non-rated pilot. Factors to the accident were fuel exhaustion, the unsuitable terrain for landing encountered by the non-rated pilot, and the rough/uneven terrain condition.NTSB FTW00RA029Accident · 18 fatalForeign investigationDouglas DC-9-31 · Uruapan, MexicoNTSB DEN00FA135Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Lake City, COthe pilot's inadequate flight planning and preparation, and his inadvertent flight into adverse weather during a cross-country flight over mountainous terrain. Contributing factors were, the cloudy obscuration weather condition, the high density altitude, and…NTSB CHI00LA030Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Saint Charles, MOthe pilot's failure to maintain directional control on landing. A factor was the crosswind.NTSB ATL00LA011Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Hollandale, MSThe certified flight instructor's inadequate supervision of the landing and the student pilot's failure to relinquish the flight controls when the certified flight instructor attempted to recover from a bounced landing.NTSB ATL00LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Jacksonville, FLThe failure of the left main landing gear down locking mechanism for undetermined reasons.NTSB NYC00LA030Accident · No injuriesLimited investigationFinal reportCessna 150 · New Hope, PAThe pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.NTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…NTSB MIA00WA024Accident · 4 fatalForeign investigationBeech 58 · Abidjan, MaliNTSB DEN00IA075Incident · No injuriesIncident investigationFinal reportBeech A60 · Boulder, COThe fatigue failure of the #6 cylinder connecting rod cap.NTSB NYC00LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Factoryville, PAThe pilot's failure to maintain aircraft control during a crosswind landing.NTSB MIA00LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Olive Branch, MSThe private-rated student pilots inadvertent retraction of the main landing gear during a touch-and-go landing. Contributing to the accident was the flight instructors improper supervision of the dual student.NTSB LAX00FA041Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30F · Honolulu, HIThe pilot-in-command initiated an evasive manuver during a near midair collission. The airplane entered a prestall buffet, which resulted in buckling of the elevator skins.NTSB CHI00LA025Accident · No injuriesLimited investigationFinal reportMancini Vans RV-4 · North Platte, NEaircraft control not being maintained by the pilot. A factor to the accident was the crosswind weather condition.NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.NTSB IAD00WA004Accident · 2 fatalForeign investigationHughes 369D · Cologne, GermanyNTSB DEN00LA016Accident · No injuriesLimited investigationFinal reportCessna 150E · Longmont, COThe pilot of the other aircraft's failure to follow right-of-way VFR procedures and inadequate visual lookout.NTSB CHI00LA026Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rochester, INthe pilot did not obtain the proper touchdown point. Factors included the closed runway and the culvert.NTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.NTSB ATL00FA009Accident · 1 fatalField investigationFinal reportCessna 210N · Chamblee, GAThe failure of the flex hydraulic line and the chaffing of an electrical line under the pilot seat that resulted in an inflight fire. The pilot's inflight decision to continue flight with a known airplane deficiencies.NTSB ANC00LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident was snow-covered terrain.NTSB NYC00LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Rising Sun, MDThe PIC CFI's improper planning/decision to perform a downwind takeoff. A factor in this accident was the tail wind condition.NTSB NYC00LA026Accident · Minor injuriesLimited investigationFinal reportBailey Exec 162F · Pottstown, PAThe student pilot's loss of control of the helicopter, his lack of recent experience, his lack of total experience, and his overconfidence in his personal ability. A factor in the accident was the student pilot's disregard of regulations.NTSB LAX00TA030Accident · Minor injuriesFinal reportBell OH-58A · La Puente, CAA loss of engine power for undetermined reasons.NTSB DEN00LA015Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Artesia, NMThe pilot's inadequate compensation for the wind conditions.NTSB NYC00LA025Accident · Serious injuriesLimited investigationFinal reportKnox HI-MAX · Dixfield, METhe pilot's failure to obtain the proper touchdown point. A factor in the accident was the pilot's lack of experience in make and model.NTSB MIA00LA022Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCThe flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.NTSB FTW00LA026Accident · No injuriesLimited investigationFinal reportWaco KNF · Midway, ARThe inability of the pilot to maintain control of the airplane as a result of a downdraft.NTSB DCA00WA007Accident · No injuriesForeign investigationBoeing 777-200 · London, United KingdomNTSB CHI00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Hannibal, MOthe pilot not maintaining directional of the airplane. Factors were the crosswinds and gusts.NTSB SEA00FA015Accident · No injuriesField investigationFinal reportKaman K-1200 · Emida, IDFailure of the splined engine adaptor as a result of torsional overstress. Factors include a worn freewheeling clutch assembly.NTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.NTSB FTW00LA025Accident · Minor injuriesLimited investigationFinal reportStreifthau Baby Great Lakes · Iowa Park, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB FTW00LA024Accident · No injuriesLimited investigationFinal reportCessna A188B · Seminole, TXThe pilot's failure to maintain clearance with the powerlines.