Skip to content

NTSB investigations: NONE, 1973

45 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: NONE, 1973 per year, 1964–2026: 2,123 cases
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

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") = 1973 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

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\") = 1973
    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") = 1973
  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

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 LAX74DUM14Accident · Serious injuriesClosedSchweizer SGU222 · San Diego, CADec 11, 1973 · N2718Z · Substantial damage NTSB OAK74FVG20Accident · 1 fatalClosedSemco T · Chico, CADec 8, 1973 · N9975 · Substantial damage NTSB LAX74DUG28Accident · No injuriesClosedSchweizer SGS126 · Llano, CADec 8, 1973 · N7582 · Substantial damage NTSB LAX74DUG26Accident · No injuriesClosedCessna TU206C · Perris, CANov 25, 1973 · N3958G · 2 aircraft · Substantial damage NTSB NYC74DHA12Accident · No injuriesClosedBlanik L-13 · Erwinna, PAOct 7, 1973 · N90598 · Substantial damage NTSB OAK74FVG16Accident · Serious injuriesClosedSemco T · Sacremento, CASep 29, 1973 · N9975 · Substantial damage NTSB MIA74FLD25Accident · No injuriesClosedSchweizer SGS233 · Odessa, FLSep 18, 1973 · N7591 · Substantial damage NTSB LAX74DUG32Accident · No injuriesClosedGlasflugel Libell · Bg Bear Cty, CASep 6, 1973 · N301F · Substantial damage NTSB NYC74DNC21Accident · No injuriesClosedSchweizer 126 · Franconia, NHSep 4, 1973 · N1118S · Destroyed NTSB LAX74DUJ12Accident · No injuriesClosedLet-Np-K L-13 · Tucson, AZAug 25, 1973 · N3460 · Substantial damage NTSB CHI74DEI13Accident · Serious injuriesClosedSchweizer 2-22 · Medina, OHAug 25, 1973 · N8679R · Substantial damage NTSB NYC74DHA07Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAAug 24, 1973 · N1241S · Substantial damage NTSB FTW74DQG11Accident · No injuriesClosedGlasflugel H301 · Brownfield, TXAug 19, 1973 · N767M · Substantial damage NTSB OAK74DXQ05Accident · No injuriesClosedEntwicklung Phoebs · Tahoe, CAAug 9, 1973 · N5701 · Substantial damage NTSB NYC74FHA03Accident · No injuriesClosedSchweizer 126E · Kutztown, PAJul 30, 1973 · N17908 · Substantial damage NTSB SEA74FTI07Accident · No injuriesClosedSchweizer 2-33 · Belgrade, MTJul 26, 1973 · N7758S · Substantial damage NTSB NYC74DHJ07Accident · No injuriesClosedSchweizer SGS233 · Shirley, NYJul 24, 1973 · N7555 · Substantial damage NTSB SEA74DYG06Accident · No injuriesClosedSchemp SHK-1 · Ephrata, WAJul 22, 1973 · N1582 · Substantial damage NTSB NYC74DGT03Accident · No injuriesClosedGlasflugel H301 · Fairfield, PAJul 5, 1973 · N3943 · Minor damage NTSB IAD73DKM48Accident · Minor injuriesClosedGlasflugel H301B · Cherryville, NDJun 22, 1973 · N1811T · 2 aircraft · Substantial damage NTSB MKC73DCG53Accident · Minor injuriesClosedSchweizer 1-23H · Grain Valley, MOJun 17, 1973 · N3908A · Substantial damage NTSB CHI73FEE67Accident · Serious injuriesClosedSchweizer SGU222 · Huntly, ILJun 16, 1973 · N91836 · No damage NTSB CHI73FEM66Accident · Minor injuriesClosedCherokee II · Ionia, MIJun 14, 1973 · N3200F · Substantial damage NTSB MIA73DLD88Accident · Minor injuriesClosedSchweizer SGS126 · Oviedo, FLJun 13, 1973 · N2743Z · Substantial damage NTSB CHI73FEM65Accident · No injuriesClosedSchleicher KA6CR · Ionia, MIJun 13, 1973 · N5318 · Substantial damage NTSB LAX73DUM37Accident · No injuriesClosedSchweizer SGS126 · Borrego Spg, CAMay 29, 1973 · N3835A · Substantial damage NTSB SEA73DYG34Accident · No injuriesClosedGlasflugel H301B · Ephrata, WAMay 27, 1973 · N245F · Substantial damage NTSB OAK73AP042Accident · No injuriesClosedGlasflugel H301B · Redding, CAMay 26, 1973 · N194P · 2 aircraft · Substantial damage NTSB LAX73DUG61Accident · Serious injuriesClosedSchweizer SG2-33 · Adelanto, CAMay 26, 1973 · N5718S · Minor damage NTSB NYC73FNA48Accident · Serious injuriesClosedBlanik L-13 · Plymouth, MAMay 12, 1973 · N12YA · Substantial damage NTSB DEN73DQA36Accident · Serious injuriesClosedPiccard AX-6 · Albuquerque, NMMay 5, 1973 · N28US · No damage NTSB LAX73DUJ76Accident · No injuriesClosedSchemp SH1 · Paradise V., AZApr 26, 1973 · N4279A · Substantial damage NTSB NYC73FNE30Accident · No injuriesClosedCook Tern · North Adams, MAApr 25, 1973 · N4705 · Substantial damage NTSB NYC73FGT09Accident · No injuriesClosedSchleicher II · Fairfield, PAApr 22, 1973 · N7984 · Substantial damage NTSB LAX73FUQ30Accident · Minor injuriesClosedSchweizer SGS134 · Tehachapi, CAApr 22, 1973 · N7626 · Substantial damage NTSB OAK73DXQ27Accident · No injuriesClosedCirrus Stndrd · Lovelock, NVApr 21, 1973 · N8670 · Substantial damage NTSB IAD73DKM35Accident · Serious injuriesClosedSchleicher AS-W17 · Newton, NCApr 20, 1973 · N1UJ · Substantial damage NTSB OAK73DXQ30Accident · No injuriesClosedSchweizer SGS126 · Carson City, NVApr 17, 1973 · N2423W · Substantial damage NTSB LAX73DUJ75Accident · No injuriesClosedSchemp Cirrus · San Manuel, AZApr 14, 1973 · N462E · Substantial damage NTSB FTW73DRA19Accident · No injuriesClosedSchweizer SGS126 · Friendswood, TXApr 1, 1973 · N2738Z · Substantial damage NTSB DEN73FTE67Accident · No injuriesClosedHughes 269A · Lafayette, COMar 21, 1973 · N8891F · Substantial damage NTSB OAK73DVD27Accident · Minor injuriesClosedSchweizer SGS233 · Fremont, CAMar 20, 1973 · N7547 · Substantial damage NTSB IAD73DIJ21Accident · Serious injuriesClosedSchweizer SGS233 · Huntington, WVMar 6, 1973 · N7535 · Substantial damage NTSB LAX73DUJ55Accident · No injuriesClosedSchweizer SGS232 · Maricopa, AZFeb 18, 1973 · N7770S · Substantial damage NTSB NYC73DHD21Accident · No injuriesClosedSchweizer SG233A · West Chester, PAJan 6, 1973 · N7609 · Substantial damage