NTSB investigations
180,553 investigations by the National Transportation Safety Board since 1962: 174,541 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,313 |
Where
Open the mapThe NTSB has investigated every U.S. civil aviation accident since 1967, and its records reach back to 1962. Since 2008 it also records some foreign investigations it took part in.
Latest 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 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 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 ERA27LA017Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Kinnelon, NJNTSB CEN27LA020Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182Q · Gun Barrel City, TXNTSB CEN27LA019Accident · Minor injuriesClass 3 · LimitedInvestigation openPiper PA-28-235 · Cedar Rapids, IANTSB CEN27LA018Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22 · Minneapolis, MNNTSB WPR27LA020Accident · No injuriesClass 3 · LimitedInvestigation openMaule M-7-260 · Sea Ranch, CANTSB WPR27LA019Accident · Serious injuriesClass 3 · LimitedInvestigation openCessna 177A · San Jose, CANTSB DCA27LA013Accident · Serious injuriesClass 4 · LimitedInvestigation openBombardier CL-600-2D24 · St. Louis, MONTSB GAA27WA013Accident · 2 fatalForeign investigationPiper PA38 · Dryman, United KingdomNTSB ERA27LA013Accident · No injuriesClass 3 · LimitedInvestigation openHughes 269C · Gastonia, NCNTSB ERA27LA008Accident · Minor injuriesLimited investigationInvestigation openZielke Ronald W Zenith 750 · Marysville, OHNTSB CEN27FA016Accident · 5 fatalClass 3 · FieldInvestigation openPiper PA 46-350P · Reedsburg, WINTSB GAA27WA014Accident · Serious injuriesClass 5 · ForeignChampion 7GCAA · Pattaya, ThailandNTSB GAA27WA011IncidentForeign investigationBeech 58 · San Bernardina, UruguayNTSB WPR27LA016Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-30 · Reno, NVNTSB WPR27FA015Accident · 1 fatalClass 3 · FieldInvestigation openBertling Courtney MXL-2 · Newberg, ORNTSB CEN27LA009Accident · Serious injuriesClass 3 · LimitedInvestigation openSimpson Arthur Monnett Sonerai Iilt · Sextonville, WINTSB WPR27FA014Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Aeneas, WANTSB GAA27WA010Occurrence · No injuriesClass 5 · ForeignCessna T210 · Calafquen, ChileNTSB GAA27WA008Accident · Minor injuriesForeign investigationCessna 182 · Zabaykalsky Krai, RussiaNTSB CEN27LA012Accident · No injuriesClass 4 · LimitedInvestigation openDiamond Aircraft Ind DA20-C1 · Flint, MINTSB WPR27LA017Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180H · Lewistown, MTNTSB GAA27WA007AccidentClass 5 · ForeignSteen Skybolt · Ontario, CanadaNTSB DCA27WA009Incident · No injuriesClass 5 · ForeignAirbus A320-214 · Kingston, JamaicaNTSB CEN27LA011Accident · Minor injuriesClass 4 · LimitedInvestigation openFlight Design Ctls · Yankton, SDNTSB GAA27WA012Incident · No injuriesForeign investigationPiper PA-25 · Villavicencio, ColombiaNTSB CEN27LA008Accident · No injuriesClass 4 · LimitedInvestigation openCessna 175A · Hastings, MINTSB WPR27FA012Accident · 2 fatalClass 3 · FieldInvestigation openGugger David RV-7A · Petaluma, CANTSB GAA27WA005Accident · No injuriesClass 5 · ForeignCessna R172 · Tarija, BoliviaNTSB DCA27WA012Incident · No injuriesClass 5 · ForeignAirbus A320 · Townsville, AustraliaNTSB CEN27LA007Accident · Minor injuriesClass 4 · LimitedInvestigation openKitfox III · Ward, ARNTSB CEN27FA006Accident · 1 fatalClass 3 · FieldInvestigation openAmigo Air Enterprises Lancair IV-P · Haslet, TXNTSB GAA27WA003Accident · 1 fatalClass 5 · ForeignRutan Varieze · Worplesdon, United KingdomNTSB ERA27FA004Accident · 1 fatalClass 3 · FieldInvestigation openHughes 269B · Lahmansville, WVNTSB ENG27LA001Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 777-222 · San Francisco, CANTSB WPR27LA018Accident · Serious injuriesClass 4 · LimitedInvestigation openChristen Industries Pitts S-2B · Yuma, AZNTSB GAA27WA002Accident · 2 fatalClass 5 · ForeignCessna 501 · Los Mezquites, MexicoNTSB ERA27LA016Accident · No injuriesLimited investigationInvestigation openPiper PA-31T2 · Dayton, OHNTSB CEN27LA005Accident · 2 fatalClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 · Eldorado Springs, COOn October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB WPR27LA008Accident · No injuriesClass 3 · LimitedInvestigation openHakala John Charles Lancair IV-P-T · Ontario, ORNTSB WPR27LA002Accident · No injuriesClass 3 · LimitedInvestigation openCessna P210N · Stevensville, MTNTSB DCA27WA010IncidentClass 5 · ForeignBoeing 737 · Canberra, AustraliaNTSB WPR27LA004Accident · No injuriesClass 4 · LimitedInvestigation openHead Balloons AX8-88B · Albuquerque, NMNTSB WPR27LA003Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-235C · Agua Dulce, CANTSB GAA27WA001Accident · 6 fatalForeign investigationGulfstream Gulfstream G100 · International Waters, CanadaNTSB CEN27LA002Accident · Minor injuriesClass 4 · LimitedInvestigation openPost Thorp T-18 · Brazil, INNTSB GAA27WA004Accident · No injuriesClass 5 · ForeignFairchild UC61 · Wilhelmshaven, GermanyNTSB CEN27LA004Accident · No injuriesClass 3 · LimitedInvestigation openCessna 414A · Boerne, TXNTSB WPR27LA010Accident · No injuriesLimited investigationInvestigation openCessna A185F · Madera, CANTSB WPR27LA009Accident · Serious injuriesLimited investigationInvestigation openCessna 172N · Knights Landing, CANTSB WPR27FA001Accident · 1 fatalClass 3 · FieldInvestigation openRoesler Scott D Roesler Glasair · Everett, WA