NTSB investigations, 1999
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year
| 1962 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
Where
Open the mapLatest cases
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 MIA00WA062Accident · No injuriesForeign investigationBeech 99A · St. Barthelemy, WNNTSB LAX00LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fallbrook, CAthe pilot's misjudged altitude and distance during a night landing approach, which resulted in an undershoot.NTSB DEN00LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COThe pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.NTSB CHI00LA054Accident · Minor injuriesLimited investigationFinal reportAerostar S49A · Flandreau, SDThe pilot's inadequate compensation for wind conditions, and the burner becoming disconnected from the balloon's frame. A contributing factor was the high wind condition.NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…NTSB LAX00LA066Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot's decision to takeoff downwind and the subsequent failure to achieve translational lift before contact with the water.NTSB DEN00LA034Accident · Minor injuriesLimited investigationFinal reportPrice Glasair 1-RG · Ruidoso, NMThe failure of the pilot to perform an adequate preflight, and the subsequent partial power loss as a result of water contamination in the fuel. A factor was the lack of suitable terrain for a forced landing.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB LAX00FA061Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350D · Avalon, CAA loose pneumatic fitting caused the engine to go to flight idle power at a low altitude, which resulted in a forced landing in hilly terrain.NTSB FTW00LA055Accident · No injuriesLimited investigationFinal reportCessna 172L · New Orleans, LAThe pilot's inadvertent starting of the engine. Factors were the pilot's failure to set the mixture control to the off position, and the intermittent short in the starter switch.NTSB CHI00LA052Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Indianola, IAloss of engine power for undetermined reason. A factor relating to this accident was the tree.NTSB SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.NTSB FTW00LA054Accident · No injuriesLimited investigationFinal reportCessna 150H · Sinton, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00FA053Accident · 1 fatalField investigationFinal reportMooney M20K · Mcalester, OKThe pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.NTSB LAX00LA064Accident · No injuriesLimited investigationFinal reportBeech 65-80 · Mesa, AZThe collapse of a main landing gear due to damage from a hard landing at an undetermined time.NTSB LAX00LA059Accident · Minor injuriesLimited investigationFinal reportQuest II Walsh Aventura II · Antioch, CAThe pilot's inattention to the fact that he had failed to retract the landing gear wheels prior to performing a water landing.NTSB LAX00LA058Accident · No injuriesLimited investigationFinal reportO'Hara Bob Bakeng Duce · Carson City, NVThe pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.NTSB LAX00LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gualala, CAThe student pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall/mush and a collision with the ground.NTSB LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.NTSB IAD00LA014Accident · Minor injuriesLimited investigationFinal reportPrudhomme Velocity RG 173 · Richmond, VAthe improper installation of the oil supply line to the propeller governor which resulted in a loss of lubrication, overtemperature, and a loss of engine power.NTSB CHI00FA050Accident · No injuriesField investigationFinal reportIsrael Aircraft Industries 1124A · Milwaukee, WIThe failure of the first stage pressure reducer in the oxygen regulator assembly.NTSB NYC00LA061Accident · Minor injuriesLimited investigationFinal reportZielke RV-4 · Florence, NJFailure of one of the propeller blades. A factor was the necessity land across, rather than in alignment with, the furrowed terrain due to the nature of the emergency.NTSB DEN00LA031Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · San Luis, COThe pilot's inadequate in-flight decision, and the subsequent inadvertent stall/mush. Factors were the pilot's lack of total experience in mountain flying, the high density altitude, and downdraft weather conditions.NTSB CHI00LA056Accident · No injuriesLimited investigationFinal reportCessna 210 · South Lyon, MIthe failure of the throttle and the unsuitable terrain encountered by the pilot in the taxi area. Factors were the collapsed nose gear and the rough terrain,NTSB CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.NTSB DEN00IA032Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · Salt Lake City, UTImproper assembly of the wheel during build up in the operator's maintenance facilities.NTSB CHI00LA055Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Mokane, MOfuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.NTSB ANC00LA021Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Bethel, AKThe pilot's failure to remove frost from the airplane prior to flight, and an inadvertent stall/mush.NTSB SEA00FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Hermiston, ORThe pilot's failure to maintain clearance with terrain. Factors include a dark night, low ceilings and mist.NTSB LAX00LA060Accident · No injuriesLimited investigationFinal reportPitts S-2B · Santa Ana, CAThe failure of the pilot of the other airplane to maintain an adequate obstruction clearance while taxiing.NTSB FTW00WA056Accident · 2 fatalForeign investigationCessna 414 · Apodaca, MexicoNTSB CHI00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Alexandria, MNThe pilot's inadequate inflight decision to continue flight into icing conditions. An additional cause was the directional control not maintained by the pilot. Contributing factors were the viewable area of the aircraft's heated windshield panel, in-flight…NTSB ATL00LA018Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Adjuntas, PRThe pilot continued flight into adverse weather conditions that included low ceiling and turbulence. Factors to the accident were trees.NTSB ANC00LA020Accident · No injuriesLimited investigationFinal reportCessna 185 · Chenega Bay, AKThe pilot's selection of an unsuitable takeoff area during the incoming tide. Factors associated with the accident were the incoming tide wave, and the pressure induced by the delays encountered picking up the passengers.NTSB NYC00LA056Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Port Clinton, OHLoss of engine power caused by ice crystal blockage of the fuel system.NTSB NYC00FA058Accident · 1 fatalField investigationFinal reportCessna 172P · Leominster, MAThe student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…NTSB MIA00FA058Accident · 2 fatalField investigationFinal reportAero Commander 500 · Georgetown, SCThe noninstrument-rated pilot's improper decision to attempt VFR flight into known instrument flight conditions, willful disregard of FAA Automated Flight Service Station weather forecast/weather observations, failure to maintain airspeed (VSO) while…NTSB FTW00FA052Accident · 2 fatalField investigationFinal reportBeech D95A · Boyd, TXThe instructor pilot's inadvertent stall/spin.NTSB DCA00RA017Accident · 4 fatalForeign investigationBoeing 747-200F · Stansted, United KingdomNTSB ATL00FA017Accident · 1 fatalField investigationFinal reportCessna 551 · Cordele, GAThe pilot's failure to follow the published missed approach procedures, and to maintain proper altitude. Factors contributing to the severity of the accident were the low ceilings and trees.NTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.NTSB DCA00WA016Accident · 18 fatalForeign investigationMcDonnell Douglas DC-10-30 · Guatemala City, GuatemalaNTSB ATL00LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Melbourne, FLThe certified flight instructor's improper touchdown flare that resulted in a hard landing.NTSB NYC00FA057Accident · 1 fatalField investigationFinal reportCessna 152 · N. Stonington, CTThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the pilot's lack of recent flight experience.NTSB MIA00GA057Accident · Serious injuriesFinal reportHughes OH-6A · Fort Myers, FLimproper maintenance inspection of the helicopter by unknown maintenance personnel, resulting in a worn control rod bearing being continued in service, and subsequent separation, resulting in an in-flight loss of control and a crash.NTSB MIA00FA056Accident · 1 fatalField investigationFinal reportBeech E-90 · Beaufort, SCThe pilot-in-commands failure to maintain the appropriate altitude (minimum descent altitude) during an area surveillance radar (ASR) approach, resulting in an in-flight collision with swampy terrain. Contributing to the accident was the co-pilot's failure to…NTSB NYC00LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Morristown, NJThe pilot's failure to obtain proper takeoff airspeed and his failure to follow published emergency procedures. Factors related to the accident were the pilot's inadequate preflight and water contamination of the fuel system.NTSB MIA00LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Naples, FLThe pilot's improper fuel management and selection of an empty fuel tank (auxiliary) on approach for landing. This resulted in a total loss of engine power due to fuel starvation, forced landing, and subsequent in-flight collision with terrain.NTSB NYC00LA059Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Blacksburg, VAThe pilot in command's failure to recover from a bounced landing.