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 NYC77FGM26Accident · Serious injuriesClosedSchweizer SGS126 · Brownsville, PAMay 22, 1977 · N17908 · Substantial damage NTSB NYC77FHJ21Accident · Minor injuriesClosedSchweizer 2-32 · Brookhaven, NYMay 21, 1977 · N9857E · Substantial damage NTSB MKC77FCA20Accident · No injuriesClosedSchweizer 2-33A · St Charles, MOMay 21, 1977 · N2528H · Substantial damage NTSB IAD77FIG20Accident · Minor injuriesClosedSchweizer 1-26 · Frostburg, MDMay 21, 1977 · N8668R · Substantial damage NTSB CHI77FEK19Accident · 1 fatalClosedSchweizer 1-35 · Derwent, OHMay 18, 1977 · N34291 · Substantial damage NTSB NYC77DNC32Accident · No injuriesClosedSchweizer SGS233 · Salem, NHMay 15, 1977 · N2533H · Substantial damage NTSB CHI77DET14Accident · No injuriesClosedLet-Np-K L-13 · Kendallville, INMay 15, 1977 · N2973 · Substantial damage NTSB DEN77FTE42Accident · No injuriesClosedSchwiezer SGS233 · Boulder, COMay 13, 1977 · N65829 · Substantial damage NTSB DEN77DTE38Accident · Serious injuriesClosedSchweizer 2-33A · Wellington, COMay 4, 1977 · N2624H · Substantial damage NTSB MKC77FER34Accident · Serious injuriesClosedSchweizer SGU2 · Cloquet, MNApr 17, 1977 · N2717Z · Substantial damage NTSB OAK77DVG25Accident · No injuriesClosedSchweizer SGS126 · Vacaville, CAApr 16, 1977 · N7709S · Substantial damage NTSB IAD77DLT03Accident · No injuriesClosedRaven RX6 · Huntingdon, TNApr 10, 1977 · N1035R · Substantial damage NTSB IAD77FID16Accident · 1 fatalClosedSchweizer 1-26B · Windsor, VAApr 9, 1977 · N680U · Substantial damage NTSB CHI77FEI16Accident · 1 fatalClosedSchweizer SGS233 · Liverpool, OHApr 1, 1977 · N2613H · Destroyed NTSB NYC77FGT13Accident · No injuriesClosedSchweizer 2-33A · Philipsburg, PAMar 25, 1977 · N5758S · Minor damage NTSB LAX77DUM21Accident · No injuriesClosedSchweizer SGS233 · San Diego, CAMar 12, 1977 · N5797S · Substantial damage NTSB MIA77FKT29Accident · No injuriesClosedPiper PA-25 · W.Boynton Bch, FLMar 11, 1977 · N8935L · Substantial damage NTSB LAX77DUG34Accident · Serious injuriesClosedPiccard AX-6W · Perris, CAMar 6, 1977 · N19DP · No damage NTSB MIA77DLD29Accident · No injuriesClosedSchweizer SGS126 · Arcadia, FLFeb 19, 1977 · N12W · Substantial damage NTSB NYC77FHA15Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAFeb 16, 1977 · N33993 · Substantial damage NTSB DEN77FQA23Accident · No injuriesClosedRaven S-50A · Albuquerque, NMFeb 13, 1977 · N51546 · Substantial damage NTSB MIA77FKT25Accident · No injuriesClosedSchweizer SGS233 · Homestead, FLJan 30, 1977 · N65819 · Substantial damage NTSB OAK77FVD10Accident · Minor injuriesClosedSchweizer 2-33 · Fremont, CAJan 21, 1977 · N1239S · Substantial damage NTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXDec 30, 1976 · N53DP · Destroyed NTSB OAK77DJA04Accident · Minor injuriesClosedSczeny-Roth BG12B · Mokuleia, HIDec 11, 1976 · N2262C · Substantial damage NTSB SEA77DYE05Accident · Minor injuriesClosedSchweizer SGS126 · Issaquah, WANov 28, 1976 · N65952 · Substantial damage NTSB IAD77DIA05Accident · No injuriesClosedSemco TC-4 · Warrenton, VANov 7, 1976 · N8695 · Substantial damage NTSB MIA77DLD10Accident · No injuriesClosedSchweizer SGS126 · Oviedo, FLOct 25, 1976 · N2631H · Substantial damage NTSB NYC77FHM02Accident · Serious injuriesClosedSchemp Stdcir · Minisink, NYOct 23, 1976 · N11JY · Substantial damage NTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MAOct 17, 1976 · N33977 · Destroyed NTSB CHI77DEE02Accident · Minor injuriesClosedSchweizer SGU222 · Park Forest, ILOct 3, 1976 · N681U · Substantial damage NTSB MIA77DLD88Accident · No injuriesClosedLet-Np-K L-13 · Land O Lakes, FLSep 19, 1976 · N14WG · Substantial damage NTSB SEA76DYE62Accident · No injuriesClosedSchweizer SGS233 · Monroe, WASep 18, 1976 · N5728S · Substantial damage NTSB FTW76DRG89Accident · No injuriesClosedSchweizer SGS233 · Spicewood, TXSep 5, 1976 · N1185S · Substantial damage NTSB CHI76DEM57Accident · No injuriesClosedSchemp SH1 · Lansing, MISep 5, 1976 · N12052 · Substantial damage NTSB NYC76FNE33Accident · Serious injuriesClosedSchweizer SGS126 · Sterling, MAAug 21, 1976 · N1106S · Substantial damage NTSB NYC76DHA49Accident · Minor injuriesClosedSchweizer SGS126 · Erwinna, PAAug 21, 1976 · N1102S · Substantial damage NTSB NYC76FGT26Accident · Minor injuriesClosedSchweizer SGS233 · Fredericksburg, PAAug 3, 1976 · N2440W · Substantial damage NTSB NYC76FHA44Accident · No injuriesClosedSchweizer SGS233 · Kutztown, PAAug 1, 1976 · N33920 · Substantial damage NTSB NYC76FGM41Accident · No injuriesClosedSchleicher ASW-15 · Claysburg, PAAug 1, 1976 · N15DC · Substantial damage NTSB MKC76FCJ55Accident · No injuriesClosedSchleicher K-7 · Lincoln, NEJul 28, 1976 · N8241E · Substantial damage NTSB FTW76FQD29Accident · No injuriesClosedSchweizer SGS126 · Fabens, TXJul 25, 1976 · N3908A · Substantial damage NTSB CHI76FEI36Accident · No injuriesClosedSchweizer SGU222 · Belden, OHJul 24, 1976 · N5828V · Substantial damage NTSB MKC76DCA36Accident · Serious injuriesClosedBriegleb BG-12B · Painton, MOJul 18, 1976 · N9015 · Substantial damage NTSB FTW76FQD30Accident · No injuriesClosedSchweizer SGS126 · Fabens, TXJul 7, 1976 · N8639R · Substantial damage NTSB LAX76DUG69Accident · No injuriesClosedSchweizer SGS232 · Adelanto, CAJun 19, 1976 · N697U · Substantial damage NTSB MIA76DLG34Accident · Minor injuriesClosedSchweizer SGS233 · Aiken, SCJun 15, 1976 · N7537 · Substantial damage NTSB SEA76FYG54Accident · No injuriesClosedLet-Np-K L-13 · Ephrata, WAJun 5, 1976 · N3460 · Substantial damage NTSB SEA76DYG55Accident · No injuriesClosedSchweizer SGS126 · Waterville, WAJun 5, 1976 · N7562 · Substantial damage NTSB OAK76DXQ48Accident · Minor injuriesClosedPiccard AX-6W · Quincy, CAMay 31, 1976 · N69US · Substantial damage