Skip to content

NTSB investigations: NONE, 1974

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: NONE, 1974 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") = 1974 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\") = 1974
    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") = 1974
  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 CHI75FEC19Accident · Serious injuriesClosedSchleicher AS-K13 · Adrian, MIOct 26, 1974 · N14AA · Substantial damage NTSB NYC75FNC15Accident · Minor injuriesClosedSchweizer SGS233 · Warren, VTOct 22, 1974 · N1228S · Substantial damage NTSB CHI75DEE25Accident · Serious injuriesClosedPiccard AX-6 · Harvard, ILOct 12, 1974 · N88US · No damage NTSB OAK75AP012Accident · 2 fatalClosedPiccard AX-6 · Tracy, CASep 21, 1974 · N53US · Substantial damage NTSB NYC75DFA14Accident · No injuriesClosedSchweizer SGS233 · Saratoga Sprng, NYSep 21, 1974 · N5708S · Substantial damage NTSB MIA75DKT14Accident · Serious injuriesClosedLet-Np-K L-13 · Boca Raton, FLSep 15, 1974 · N15CB · Substantial damage NTSB DEN75DQA13Accident · No injuriesClosedSchweizer SGS232 · Albuquerque, NMSep 1, 1974 · N5826V · Substantial damage NTSB LAX75DUJ31Accident · No injuriesClosedSchweizer SGS232 · Maricopa, AZAug 31, 1974 · N5795S · Substantial damage NTSB CHI75AC022Accident · Minor injuriesClosedBriegleb BG-12 · Marion, OHAug 25, 1974 · N1297 · 2 aircraft · Substantial damage NTSB LAX75DUJ23Accident · Serious injuriesClosedSchweizer SGU222 · Phoenix, AZAug 24, 1974 · N2719Z · Substantial damage NTSB OAK75FXQ14Accident · No injuriesClosedSchweizer SGS232 · Truckee, CAAug 18, 1974 · N2466W · Substantial damage NTSB LAX75DUG05Accident · No injuriesClosedSchweizer SGS134 · Helendale, CAAug 5, 1974 · N7656 · Substantial damage NTSB OAK75DVG11Accident · No injuriesClosedSemco T · Napa, CAAug 3, 1974 · N24412 · 2 aircraft · Substantial damage NTSB MKC75DCD05Accident · No injuriesClosedSchweizer 2-22 · Greenfield, IAJul 27, 1974 · N91858 · Substantial damage NTSB MIA75AM006Accident · 2 fatalClosedRaven S-60A · Tavares, FLJul 9, 1974 · N54691 · Minor damage NTSB CHI75DEM01Accident · No injuriesClosedSchemp SHI · Frankfort, MIJul 7, 1974 · N415M · Substantial damage NTSB DEN75DQA03Accident · No injuriesClosedSchweizer SGS123 · Moriarty, NMJul 6, 1974 · N91880 · Substantial damage NTSB IAD75FIA03Accident · No injuriesClosedSchweizer SGS233 · Bridgewater, VAJul 4, 1974 · N17941 · Substantial damage NTSB LAX75FUJ03Accident · No injuriesClosedSchweizer SGS126 · Phoenix, AZJul 1, 1974 · N7740S · Substantial damage NTSB LAX75DUG02Accident · No injuriesClosedGlasflugel H201B · Baker, CAJun 29, 1974 · N2578 · Substantial damage NTSB DEN74FTE92Accident · Serious injuriesClosedSchweizer SGS126 · Boulder, COJun 28, 1974 · N2416W · Substantial damage NTSB CHI74FCA03Accident · No injuriesClosedSchweizer 1-26D · Highland, ILJun 24, 1974 · N7727S · Substantial damage NTSB NYC74DHM33Accident · No injuriesClosedSchweizer 2-32 · Amenia, NYJun 21, 1974 · N2774Z · Substantial damage NTSB LAX74FUJ70Accident · No injuriesClosedSchweizer SGS233 · Phoenix, AZJun 17, 1974 · N7558 · Substantial damage NTSB IAD74FIA19Accident · Serious injuriesClosedGlasfugel H301B · Midland, VAJun 12, 1974 · N66SC · Substantial damage NTSB FTW74DPA28Accident · No injuriesClosedSailplane HP14 · Caddo Mills, TXJun 9, 1974 · N9159 · Substantial damage NTSB MKC74DCD37Accident · No injuriesClosedSchweizer 2-33A · Greenfield, IAJun 2, 1974 · N5781S · Substantial damage NTSB MIA74DLA45Accident · No injuriesClosedCessna 188 · Trenton, FLMay 28, 1974 · N8275G · Substantial damage NTSB IAD74FIA16Accident · No injuriesClosedFlug-Undfah DIA-18 · Latrobe, PAMay 13, 1974 · N1111H · Substantial damage NTSB OAK74DVA65Accident · No injuriesClosedSchweizer SGS126 · Del Piedra, CAMay 12, 1974 · N7753S · Substantial damage NTSB OAK74DVG57Accident · No injuriesClosedSchempp ST CIR · Kelseyville, CAMay 11, 1974 · N184N · Substantial damage NTSB OAK74DVG53Accident · Serious injuriesClosedSemco 105P · Napa, CAMay 5, 1974 · N8697 · Minor damage NTSB LAX74DUJ59Accident · Minor injuriesClosedSchweizer SGS233 · Phoenix, AZApr 27, 1974 · N7778S · Substantial damage NTSB NYC74FNA41Accident · Serious injuriesClosedSchweizer 2-33 · Plymouth, MAApr 21, 1974 · N2489W · Substantial damage NTSB NYC74DNC39Accident · No injuriesClosedSchweizer SG1-26 · Hollis, NHApr 20, 1974 · N1109S · Destroyed NTSB OAK74DVG41Accident · Minor injuriesClosedSchweizer SGU222 · Shingle Spg, CAApr 14, 1974 · N2764R · Substantial damage NTSB OAK74DXQ41Accident · No injuriesClosedAer-Pegaso M-100S · Silver Sprngs, NVApr 11, 1974 · N123R · Substantial damage NTSB OAK74DVW17Accident · Minor injuriesClosedBowlus BA-100 · Henderson, NVApr 8, 1974 · N28387 · Substantial damage NTSB OAK74FXQ30Accident · Minor injuriesClosedSlingsby T53B · Minden, NVApr 6, 1974 · N11CC · Substantial damage NTSB LAX74DUG51Accident · No injuriesClosedSchweizer SGS126 · Adelanto, CAMar 31, 1974 · N3854A · Substantial damage NTSB MKC74DCQ31Accident · Serious injuriesClosedStokes AIR · El Dorado, KSMar 17, 1974 · N94465 · Substantial damage