Skip to content

NTSB investigations: NONE

2,123 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, newest first

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 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 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 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 LAX68D0178Accident · Minor injuriesClosedSchweizer SGS233 · Adelanto, CAOct 8, 1967 · N2430W · Substantial damage NTSB FTW68D0278Accident · No injuriesClosedSchweizer SGU-2 · Big Spring, TXSep 30, 1967 · N10351 · Substantial damage NTSB CHI68F0345Accident · Serious injuriesClosedScheibe Spatz · Marion, OHSep 23, 1967 · N247RH · Substantial damage NTSB NYC68D0166Accident · No injuriesClosedSchweizer SGU222 · West Chester, PASep 11, 1967 · N9918J · Substantial damage NTSB NYC68D0169Accident · No injuriesClosedCessna 305A · Salem, NHAug 13, 1967 · N1836 · 2 aircraft · Substantial damage NTSB NYC68F0109Accident · Minor injuriesClosedCherokee II · Hershey, PAAug 12, 1967 · N10342 · Substantial damage NTSB OAK68D0185Accident · Minor injuriesClosedSchweizer SGS2-8 · Auburn, CAJul 29, 1967 · N50796 · Destroyed NTSB NYC68D0065Accident · No injuriesClosedSchleicher K7 · Middlesex, NYJul 9, 1967 · N4771G · Substantial damage NTSB DEN68D0039Accident · No injuriesClosedSchweizer SGS126 · Espanola, NMJul 8, 1967 · N8676R · Substantial damage NTSB LAX68D0055Accident · Minor injuriesClosedSchweizer SGS2-8 · Elsinore, CAJul 7, 1967 · N53285 · Substantial damage NTSB CHI68D0096Accident · No injuriesClosedSchleicher KA-6CR · Genoa, OHJul 3, 1967 · N4600T · Substantial damage NTSB DEN68D0027Accident · No injuriesClosedAer-Pegaso M100S · Boulder, COJun 25, 1967 · N69280 · Substantial damage NTSB DEN68F0013Accident · No injuriesClosedSchleicher K8 · Heber City, UTJun 17, 1967 · N91274 · Substantial damage NTSB DEN67D0286Accident · No injuriesClosedSchweizer SGS1 · Ruidoso, NMMay 30, 1967 · N91880 · Substantial damage NTSB NYC68F0003Accident · Serious injuriesClosedSchweizer SGU222 · Butler, PAMay 21, 1967 · N2749Z · Substantial damage NTSB MKC67F0581Accident · No injuriesClosedSchweizer SGU-2 · Red Wing, MNMay 6, 1967 · N5823V · Substantial damage NTSB LAX67D0428Accident · No injuriesClosedSchweitzer SGS126 · Adelanto, CAMay 6, 1967 · N10387 · Substantial damage NTSB NYC67D0610Accident · Minor injuriesClosedSchweitzer 1-26 · Wurtsboro, NYApr 2, 1967 · N679U · Substantial damage NTSB OAK67D0308Accident · No injuriesClosedSchweitzer 1-26A · Carson City, NVMar 25, 1967 · N8688R · Substantial damage NTSB NYC67D0328Accident · Minor injuriesClosedSchweizer SGA126 · Waverly, NYOct 6, 1966 · N923X · Substantial damage NTSB OAK67D0147Accident · Serious injuriesClosedPiccard Bal AX6 · Reno, NVSep 22, 1966 · N88952 · No damage NTSB OAK67D0158Accident · No injuriesClosedSchweizer SGS126 · Truckee, CASep 10, 1966 · N2724Z · Substantial damage NTSB DEN67F0094Accident · Serious injuriesClosedSchweizer TG-3A · Casper, WYAug 28, 1966 · N9305H · Substantial damage NTSB NYC67F0184Accident · Minor injuriesClosedSchweitzer SGS126 · Warren, VTAug 9, 1966 · N9924J · Substantial damage NTSB FTW67D0171Accident · Serious injuriesClosedSchweizer SGS126 · Mccamey, TXAug 6, 1966 · N3886A · Minor damage NTSB MKC67D0053Accident · No injuriesClosedPrue 215A · Wilbur, NEJul 14, 1966 · N454Y · Substantial damage NTSB CHI66F0012Accident · Serious injuriesClosedSchweizer SGU222 · Bay City, WIJun 18, 1966 · N10399 · Destroyed NTSB OAK67F0011Accident · Serious injuriesClosedSchweiger SGS126 · Livermore, CAJun 11, 1966 · N3858A · 2 aircraft · Substantial damage NTSB OAK66D0300Accident · No injuriesClosedOberlerchnr MG23 · Sheridan, CAMay 21, 1966 · N6729C · Substantial damage NTSB DEN66D0316Accident · No injuriesClosedSchweizer 2-32 · Laguna, NMMay 21, 1966 · N2767Z · Substantial damage NTSB OAK66D0284Accident · Minor injuriesClosedAero-Pegaso M-100S · Livermore, CAApr 17, 1966 · N88981 · Substantial damage NTSB DEN66A0073Accident · No injuriesClosedHughes 269A · Arvada, WYApr 5, 1966 · N8891F · Substantial damage NTSB OAK66D0219Accident · Minor injuriesClosedSchweitzer SGS126 · Fremont, CAMar 14, 1966 · N2715Z · Substantial damage NTSB FTW66D0577Accident · Minor injuriesClosedSchweizer SGS126 · Odessa, TXMar 13, 1966 · N3814A · Substantial damage NTSB CHI66F0407Accident · 1 fatalClosedSchweizer SGS126 · Ramsey, INOct 31, 1965 · N8633R · Substantial damage NTSB NYC66D0138Accident · No injuriesClosedSchweizer SGU-2 · Flatbrookville, NJAug 5, 1965 · N8609R · Substantial damage NTSB CHI66D0137Accident · No injuriesClosedSchleicher KA7 · Jefferson, OHJul 31, 1965 · N4280C · Substantial damage NTSB NYC66D0130Accident · No injuriesClosedScheibe L-SPAT · Heath, MAJul 30, 1965 · N8752R · Substantial damage NTSB CHI66F0138Accident · No injuriesClosedSchweizer 2-22E · Oak Brook, ILJul 20, 1965 · N684U · Substantial damage NTSB FTW66F0210Accident · Serious injuriesClosedSchweizer SGS126 · Guthrie, OKJul 8, 1965 · N2776Z · Substantial damage NTSB NYC66D0090Accident · Serious injuriesClosedSchweizer SGU222 · Newcastle, VAJul 5, 1965 · N10330 · Substantial damage NTSB CHI66D0134Accident · Minor injuriesClosedSchleicher K7 · Jefferson, OHJun 24, 1965 · N4700G · Substantial damage NTSB DEN66F0015Accident · No injuriesClosedGrasshopper D-8 · Heber, UTJun 12, 1965 · N5053K · Destroyed NTSB NYC65D0242Accident · Minor injuriesClosedSchemp SH1 · Strasburg, VAMay 31, 1965 · N814Z · Substantial damage NTSB MKC66D0017Accident · No injuriesClosedCessna 140 · Lamberton, MNMay 30, 1965 · N89297 · Substantial damage NTSB DEN66D0014Accident · No injuriesClosedSchweizer SGU222 · Alamogordo, NMMay 30, 1965 · N2728Z · Substantial damage NTSB DEN65D0099Accident · No injuriesClosedSchweizer TG-2 · Aspen, COMay 30, 1965 · N67660 · Substantial damage NTSB MIA65F0121Accident · Serious injuriesClosedSchweitzer SGS126 · Titusville, FLMay 23, 1965 · N12W · Substantial damage NTSB MKC65F0154Accident · 1 fatalClosedSchweizer SGS126 · Papillion, NEMay 16, 1965 · N2768R · Destroyed NTSB NYC65F0147Accident · Serious injuriesClosedSchweizer SGU · Mars, PAApr 11, 1965 · N2749Z · Substantial damage