NTSB investigations, 1974, AZ
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
| 1963 | 1 |
|---|---|
| 1964 | 130 |
| 1965 | 107 |
| 1966 | 128 |
| 1967 | 138 |
| 1968 | 114 |
| 1969 | 115 |
| 1970 | 102 |
| 1971 | 128 |
| 1972 | 101 |
| 1973 | 105 |
| 1974 | 101 |
| 1975 | 121 |
| 1976 | 105 |
| 1977 | 123 |
| 1978 | 149 |
| 1979 | 130 |
| 1980 | 114 |
| 1981 | 132 |
| 1982 | 123 |
| 1983 | 114 |
| 1984 | 84 |
| 1985 | 78 |
| 1986 | 77 |
| 1987 | 76 |
| 1988 | 61 |
| 1989 | 79 |
| 1990 | 68 |
| 1991 | 86 |
| 1992 | 88 |
| 1993 | 68 |
| 1994 | 65 |
| 1995 | 73 |
| 1996 | 68 |
| 1997 | 71 |
| 1998 | 54 |
| 1999 | 64 |
| 2000 | 61 |
| 2001 | 63 |
| 2002 | 76 |
| 2003 | 93 |
| 2004 | 72 |
| 2005 | 81 |
| 2006 | 77 |
| 2007 | 66 |
| 2008 | 73 |
| 2009 | 74 |
| 2010 | 63 |
| 2011 | 67 |
| 2012 | 61 |
| 2013 | 54 |
| 2014 | 62 |
| 2015 | 42 |
| 2016 | 40 |
| 2017 | 50 |
| 2018 | 60 |
| 2019 | 47 |
| 2020 | 36 |
| 2021 | 44 |
| 2022 | 53 |
| 2023 | 43 |
| 2024 | 41 |
| 2025 | 45 |
| 2026 | 46 |
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\" = 'AZ' 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" = 'AZ' 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 LAX75FUJ51Accident · No injuriesClosedHelio Acft H-295 · Carefree, AZNTSB LAX75DUJ59Accident · No injuriesClosedCessna 182J · Tucson, AZNTSB LAX75DUJ48Accident · No injuriesClosedCessna 150 · Phoenix, AZNTSB LAX75FUJ47Accident · 1 fatalClosedCessna 210 · Maricopa, AZNTSB LAX75AL032Accident · Serious injuriesClosedBoeing 707 · Phoenix, AZNTSB LAX75DUJ46Accident · No injuriesClosedBellanca 17-30 · Show Low, AZNTSB LAX75FUJ43Accident · No injuriesClosedPiper PA-24 · Phoenix, AZNTSB LAX75DUJ44Accident · No injuriesClosedCessna 172 · Window Rock, AZNTSB LAX75AL025Accident · 1 fatalClosedSud Avn SA315B · Springervl, AZNTSB LAX75FUJ42Accident · Minor injuriesClosedCessna 310K · Glendale, AZNTSB LAX75DUJ45Accident · No injuriesClosedBrantly B-2 · Mesa, AZNTSB LAX75DUJ39Accident · Minor injuriesClosedCessna 172K · Snowflake, AZNTSB LAX75DUJ41Accident · Minor injuriesClosedCessna 182 · Sprngrville, AZNTSB LAX75AL021Accident · 2 fatalClosedCessna 172M · Fort Apache, AZNTSB LAX75FU537Accident · Serious injuriesClosedDuci Sdwndr · Peoria, AZNTSB LAX75FUJ40Accident · No injuriesClosedCessna 170B · Casa Grande, AZNTSB LAX75DUJ36Accident · No injuriesClosedGrumman G-164A · Roll, AZNTSB LAX75DUJ35Accident · No injuriesClosedSanders MM-1 · Phoenix, AZNTSB LAX75DUJ38Accident · No injuriesClosedCessna 177RG · Peoria, AZNTSB LAX75DUJ34Accident · No injuriesClosedGrumman G-164 · Aguila, AZNTSB LAX75DUJ28Accident · Minor injuriesClosedStinson 108-2 · Rillito, AZNTSB LAX75AL017Accident · 1 fatalClosedCessna 340 · Phoenix, AZNTSB LAX75DUJ30Accident · Serious injuriesClosedCessna 188 · Gadson, AZNTSB LAX75DUJ29Accident · Minor injuriesClosedBeech S35 · Rimrock, AZNTSB LAX75FUJ33Accident · Serious injuriesClosedCessna 182 · Phoenix, AZNTSB LAX75FUJ32Accident · No injuriesClosedCessna 188A · Poston, AZNTSB LAX75DUJ26Accident · No injuriesClosedCessna 182 · Cottonwood, AZNTSB LAX75DUJ25Accident · Serious injuriesClosedAero Comdr S-2D · Willcox, AZNTSB LAX75DUJ24Accident · Serious injuriesClosedStinson 108-3 · Grnd Canyon, AZNTSB LAX75AL011Accident · 1 fatalClosedPiper PA-22 · Theba, AZNTSB LAX75DUJ31Accident · No injuriesClosedSchweizer SGS232 · Maricopa, AZNTSB LAX75AL010Accident · 2 fatalClosedBeech 95-B55 · Pioneer, AZNTSB LAX75FUJ27Accident · No injuriesClosedMooney M20C · Stanfield, AZNTSB LAX75DUJ23Accident · Serious injuriesClosedSchweizer SGU222 · Phoenix, AZNTSB LAX75DUJ22Accident · No injuriesClosedGrumman G-164A · Buckeye, AZNTSB LAX75AL008Accident · 2 fatalClosedCessna 310C · Holbrook, AZNTSB LAX75FUJ21Accident · No injuriesClosedCessna A150L · Marana, AZNTSB LAX75FUJ16Accident · 2 fatalClosedCessna 150K · New River, AZNTSB LAX75DUJ18Accident · Minor injuriesClosedCessna T206B · Nogales, AZNTSB LAX75FUJ15Accident · No injuriesClosedCessna 210C · Phoenix, AZNTSB LAX75FUJ20Accident · No injuriesClosedPiper PA-25 · Tucson, AZNTSB LAX75DUJ19Accident · No injuriesClosedNaval Fcty N3N-1 · Queen Creek, AZNTSB LAX75DUJ12Accident · No injuriesClosedErco 415-CD · Wilcox, AZNTSB LAX75FUJ11Accident · No injuriesClosedWittman W-8 · Casa Grande, AZNTSB LAX75DUJ17Accident · No injuriesClosedPiper PA-25 · Stanfield, AZNTSB LAX75DUJ13Accident · Minor injuriesClosedAero Comdr Lark · Window Rock, AZNTSB LAX75DUJ14Accident · Serious injuriesClosedHiller Acft UH-12E · Gadsden, AZNTSB LAX75DUJ10Accident · Minor injuriesClosedCessna 150 · Chandler, AZNTSB LAX75FUJ09Accident · Serious injuriesClosedPiper PA-28 · Douglas, AZNTSB LAX75FUJ06Accident · No injuriesClosedPiper PA-28 · Surprise, AZ