NTSB investigations, 1974, CA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 10 |
|---|---|
| 1963 | 11 |
| 1964 | 659 |
| 1965 | 654 |
| 1966 | 755 |
| 1967 | 799 |
| 1968 | 668 |
| 1969 | 613 |
| 1970 | 617 |
| 1971 | 605 |
| 1972 | 510 |
| 1973 | 499 |
| 1974 | 523 |
| 1975 | 488 |
| 1976 | 484 |
| 1977 | 497 |
| 1978 | 548 |
| 1979 | 473 |
| 1980 | 472 |
| 1981 | 403 |
| 1982 | 391 |
| 1983 | 441 |
| 1984 | 388 |
| 1985 | 329 |
| 1986 | 316 |
| 1987 | 315 |
| 1988 | 322 |
| 1989 | 289 |
| 1990 | 318 |
| 1991 | 291 |
| 1992 | 277 |
| 1993 | 260 |
| 1994 | 242 |
| 1995 | 237 |
| 1996 | 223 |
| 1997 | 182 |
| 1998 | 212 |
| 1999 | 186 |
| 2000 | 222 |
| 2001 | 183 |
| 2002 | 176 |
| 2003 | 182 |
| 2004 | 171 |
| 2005 | 191 |
| 2006 | 187 |
| 2007 | 207 |
| 2008 | 158 |
| 2009 | 187 |
| 2010 | 158 |
| 2011 | 141 |
| 2012 | 134 |
| 2013 | 128 |
| 2014 | 117 |
| 2015 | 118 |
| 2016 | 119 |
| 2017 | 162 |
| 2018 | 119 |
| 2019 | 114 |
| 2020 | 105 |
| 2021 | 94 |
| 2022 | 111 |
| 2023 | 103 |
| 2024 | 101 |
| 2025 | 91 |
| 2026 | 82 |
Where
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
WHERE year(c.\"eventDate\") = 1974
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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") = 1974 AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 OAK75DVA38Accident · No injuriesClosedHiller Acft UH-12C · Kettlmn Cty, CANTSB LAX75FUA19Accident · No injuriesClosedCessna 172K · Avalon, CANTSB OAK75AP030Accident · 2 fatalClosedCessna 172L · 3 Rivers, CANTSB LAX75FUD03Accident · No injuriesClosedCessna 172M · Snta Monica, CANTSB LAX75FUA20Accident · Minor injuriesClosedCessna 182G · Buena Park, CANTSB OAK75FVM18Accident · No injuriesClosedGlobe GC-1B · Palo Alto, CANTSB OAK75DVD30Accident · No injuriesClosedCulver V · Sonoma, CANTSB OAK75AP028Accident · 1 fatalClosedAmer Avco AA1-A · Newark, CANTSB LAX75DVA40Accident · No injuriesClosedBeech B35 · Bakersfield, CANTSB LAX75DUG25Accident · Minor injuriesClosedPiper PA-20 · Rubidoux, CANTSB OAK75AP027Accident · 6 fatalClosedPiper PA-32 · Hlf Moon By, CANTSB LAX75FUG24Accident · Serious injuriesClosedAeronca 7BCM · Elsinore, CANTSB OAK75DVD28Accident · Minor injuriesClosedCessna 182 · Santa Rosa, CANTSB OAK75FVG42Accident · No injuriesClosedCessna 150 · Chico, CANTSB OAK75DXQ32Accident · No injuriesClosedCessna 172 · Truckee, CANTSB OAK75AP026Accident · 8 fatalClosedCessna 414 · Chester, CANTSB OAK75DXQ31Accident · Minor injuriesClosedCessna 182 · Mammoth Lks, CANTSB OAK75AP025Accident · 1 fatalClosedBell 47G3B1 · Auburn, CANTSB LAX75FUQ19Accident · Serious injuriesClosedPiper PA-28 · Van Nuys, CANTSB OAK75DVD25Accident · No injuriesClosedCessna 150 · Danville, CANTSB OAK75FVM17Accident · No injuriesClosedCessna 172D · San Carlos, CANTSB OAK75DVD26Accident · No injuriesClosedFairchild PT-26B · Livermore, CANTSB OAK75FVA36Accident · No injuriesClosedPiper PA-31P · Fresno, CANTSB OAK75DVG41Accident · No injuriesClosedBeech 35 · Gridley, CANTSB OAK75DVG40Accident · No injuriesClosedCessna 172 · Orland, CANTSB OAK75AP031Accident · 2 fatalClosedAmer Avco AA1-B · Vacaville, CANTSB OAK75FVM15Accident · No injuriesClosedCessna 150 · Woodside, CANTSB LAX75DUG27Accident · No injuriesClosedCessna 150 · Colton, CANTSB LAX75FUG21Accident · No injuriesClosedCessna 150F · Ontario, CANTSB OAK75DVD36Accident · No injuriesClosedCessna 172M · Stockton, CANTSB LAX75AL031Accident · 4 fatalClosedCessna 172 · S.Luis Obsp, CANTSB OAK75AP021Accident · 3 fatalClosedBeech H35 · Hayward, CANTSB OAK75AP020Accident · 1 fatalClosedCessna 170B · Santa Cruz, CANTSB LAX75D4G23Accident · No injuriesClosedStinson 108-1 · Rubidoux, CANTSB OAK75DVG39Accident · No injuriesClosedCessna 150 · Alleghany, CANTSB OAK75DVG38Accident · No injuriesClosedChampion 7AC · Manton, CANTSB LAX75FVM14Accident · Minor injuriesClosedCessna 177 · Paso Robles, CANTSB LAX75FUQ18Accident · No injuriesClosedBeech B19 · Lancaster, CANTSB OAK75DVG37Accident · No injuriesClosedCessna 150 · Pope Valley, CANTSB LAX75FUA16Accident · No injuriesClosedStarduster TOO · Long Beach, CANTSB LAX75FNG20Accident · No injuriesClosedCessna 150F · La Verne, CANTSB LAX75DUM11Accident · Minor injuriesClosedPiper PA-18 · Imperial, CANTSB OAK75DVG36Accident · No injuriesClosedCessna 150 · Yuba City, CANTSB LAX75DUM12Accident · Minor injuriesClosedMooney M20A · Oceanside, CANTSB LAX75AL028Accident · 3 fatalClosedBeech D18S · Tustin, CANTSB LAX75DUG22Accident · No injuriesClosedBell 47G3B1 · Joshua Tree, CANTSB LAX75AL029Accident · 1 fatalClosedBeech B19 · Tehachapi, CANTSB LAX75DVA34Accident · No injuriesClosedAero Comdr 680E · Bakersfield, CANTSB LAX75DUM10Accident · No injuriesClosedCessna 150 · Banner, CANTSB OAK75FVA35Accident · No injuriesClosedAlouette SA315B · Bear Valley, CA