NTSB investigations: NONE, 1976
41 cases on aircraft whose registry engine model is NONE. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 20 |
|---|---|
| 1965 | 19 |
| 1966 | 15 |
| 1967 | 25 |
| 1968 | 32 |
| 1969 | 27 |
| 1970 | 31 |
| 1971 | 30 |
| 1972 | 25 |
| 1973 | 45 |
| 1974 | 41 |
| 1975 | 49 |
| 1976 | 41 |
| 1977 | 51 |
| 1978 | 55 |
| 1979 | 46 |
| 1980 | 60 |
| 1981 | 42 |
| 1982 | 38 |
| 1983 | 64 |
| 1984 | 58 |
| 1985 | 45 |
| 1986 | 50 |
| 1987 | 31 |
| 1988 | 39 |
| 1989 | 25 |
| 1990 | 34 |
| 1991 | 37 |
| 1992 | 36 |
| 1993 | 37 |
| 1994 | 42 |
| 1995 | 34 |
| 1996 | 45 |
| 1997 | 39 |
| 1998 | 37 |
| 1999 | 29 |
| 2000 | 30 |
| 2001 | 44 |
| 2002 | 34 |
| 2003 | 35 |
| 2004 | 38 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 38 |
| 2008 | 33 |
| 2009 | 33 |
| 2010 | 36 |
| 2011 | 28 |
| 2012 | 28 |
| 2013 | 24 |
| 2014 | 24 |
| 2015 | 24 |
| 2016 | 22 |
| 2017 | 19 |
| 2018 | 26 |
| 2019 | 20 |
| 2020 | 19 |
| 2021 | 24 |
| 2022 | 25 |
| 2023 | 17 |
| 2024 | 23 |
| 2025 | 18 |
| 2026 | 19 |
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\") = 1976
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
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") = 1976
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXNTSB OAK77DJA04Accident · Minor injuriesClosedSczeny-Roth BG12B · Mokuleia, HINTSB SEA77DYE05Accident · Minor injuriesClosedSchweizer SGS126 · Issaquah, WANTSB IAD77DIA05Accident · No injuriesClosedSemco TC-4 · Warrenton, VANTSB MIA77DLD10Accident · No injuriesClosedSchweizer SGS126 · Oviedo, FLNTSB NYC77FHM02Accident · Serious injuriesClosedSchemp Stdcir · Minisink, NYNTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MANTSB CHI77DEE02Accident · Minor injuriesClosedSchweizer SGU222 · Park Forest, ILNTSB MIA77DLD88Accident · No injuriesClosedLet-Np-K L-13 · Land O Lakes, FLNTSB SEA76DYE62Accident · No injuriesClosedSchweizer SGS233 · Monroe, WANTSB FTW76DRG89Accident · No injuriesClosedSchweizer SGS233 · Spicewood, TXNTSB CHI76DEM57Accident · No injuriesClosedSchemp SH1 · Lansing, MINTSB NYC76FNE33Accident · Serious injuriesClosedSchweizer SGS126 · Sterling, MANTSB NYC76DHA49Accident · Minor injuriesClosedSchweizer SGS126 · Erwinna, PANTSB NYC76FGT26Accident · Minor injuriesClosedSchweizer SGS233 · Fredericksburg, PANTSB NYC76FHA44Accident · No injuriesClosedSchweizer SGS233 · Kutztown, PANTSB NYC76FGM41Accident · No injuriesClosedSchleicher ASW-15 · Claysburg, PANTSB MKC76FCJ55Accident · No injuriesClosedSchleicher K-7 · Lincoln, NENTSB FTW76FQD29Accident · No injuriesClosedSchweizer SGS126 · Fabens, TXNTSB CHI76FEI36Accident · No injuriesClosedSchweizer SGU222 · Belden, OHNTSB MKC76DCA36Accident · Serious injuriesClosedBriegleb BG-12B · Painton, MONTSB FTW76FQD30Accident · No injuriesClosedSchweizer SGS126 · Fabens, TXNTSB LAX76DUG69Accident · No injuriesClosedSchweizer SGS232 · Adelanto, CANTSB MIA76DLG34Accident · Minor injuriesClosedSchweizer SGS233 · Aiken, SCNTSB SEA76FYG54Accident · No injuriesClosedLet-Np-K L-13 · Ephrata, WANTSB SEA76DYG55Accident · No injuriesClosedSchweizer SGS126 · Waterville, WANTSB OAK76DXQ48Accident · Minor injuriesClosedPiccard AX-6W · Quincy, CANTSB NYC76FNE21Accident · Minor injuriesClosedSchweizer SGS135 · Plymouth, CTNTSB OAK76FVW25Accident · No injuriesClosedSchweizer SGS233 · Henderson, NVNTSB NYC76FGT23Accident · No injuriesClosedSchweizer SGS126 · Monterey, PANTSB MKC76FCD41Accident · Minor injuriesClosedRaven RX-6 · Carlisle, IANTSB DEN76DQA44Accident · No injuriesClosedRaven S-55A · Albuquerque, NMNTSB MIA76DKG56Accident · Serious injuriesClosedRaven RX-6 · Albany, GANTSB LAX76FUQ35Accident · No injuriesClosedGlasflugel H-301B · Inyokern, CANTSB FTW76FQD20Accident · Minor injuriesClosedSchweizer SGS232 · Fabens, TXNTSB NYC76DFJ17Accident · Minor injuriesClosedSchweizer SGS233 · Elmira, NYNTSB MIA76FLD48Accident · No injuriesClosedSchweizer SGS233 · Oviedo, FLNTSB LAX76DUG44Accident · No injuriesClosedSchweizer SGS233 · Adelanto, CANTSB LAX76DUQ30Accident · No injuriesClosedLet-Np-K L-13 · California Cty, CANTSB MIA76DLA32Accident · No injuriesClosedSchweizer SGS233 · Archer, FLNTSB MIA76DLA30Accident · No injuriesClosedSchweizer SGS126 · Quincy, FL