Skip to content

NTSB investigations: Continental 0-200 series

6,416 cases on aircraft whose registry engine model is Continental 0-200 series. 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 ('17020')) 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 ('17020'))
  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 ('17020'))
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 IAD77FLJ05Accident · Minor injuriesClosedCessna 150 · Woodland, NCNov 5, 1976 · N63283 · Substantial damage NTSB NYC77FNC06Accident · Minor injuriesClosedCessna 150M · Cherryfield, MENov 2, 1976 · N760CA · Substantial damage NTSB LAX77FUG04Accident · No injuriesClosedCessna 150 · Ettiwanda, CAOct 29, 1976 · N45394 · Substantial damage NTSB IAD77DKM06Accident · No injuriesClosedCessna 150 · Banner Elk, NCOct 29, 1976 · N88656 · Substantial damage NTSB NYC77FHD03Accident · No injuriesClosedCessna 150M · Waterford, NJOct 22, 1976 · N7986U · Substantial damage NTSB MKC77FCG03Accident · Minor injuriesClosedCessna 120 · Waldron, MOOct 17, 1976 · N1980V · 2 aircraft · Destroyed NTSB IAD77FLQ02Accident · No injuriesClosedCessna 150 · Hopkinsville, KYOct 16, 1976 · N23270 · Substantial damage NTSB IAD77DIG03Accident · No injuriesClosedCessna 150 · Easton, MDOct 16, 1976 · N7574U · Substantial damage NTSB ANC77DAG21Accident · No injuriesClosedCessna 150 · Kodiak, AKOct 14, 1976 · N51355 · Substantial damage NTSB ANC77DAA02Accident · No injuriesClosedCessna 150 · Galena, AKOct 14, 1976 · N19251 · Substantial damage NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB LAX77FWG03Accident · No injuriesClosedCessna 150 · Chino, CAOct 9, 1976 · N8729S · Substantial damage NTSB FTW76FPA01Accident · No injuriesClosedCessna 150 · Bonham, TXOct 9, 1976 · N5531G · Substantial damage NTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMOct 5, 1976 · N3643J · Substantial damage NTSB CHI77FEM06Accident · No injuriesClosedCessna 150 · Lansing, MIOct 3, 1976 · N10747 · Substantial damage NTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 30, 1976 · N45230 · Substantial damage NTSB MKC76DCH01Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 29, 1976 · N8013S · Substantial damage NTSB CHI76FEK32Accident · No injuriesClosedCessna 150 · Columbus, OHSep 28, 1976 · N51258 · Substantial damage NTSB FTW76FPM31Accident · No injuriesClosedCessna 150 · Yanush, OKSep 24, 1976 · N6626T · Substantial damage NTSB MIA76FKK04Accident · No injuriesClosedCessna 150 · Pell City, ALSep 21, 1976 · N5970G · Destroyed NTSB FTW76FPH14Accident · Serious injuriesClosedCessna 150 · Searcy, ARSep 21, 1976 · N6936F · Destroyed NTSB CHI76FEC65Accident · Minor injuriesClosedCessna 150H · Willis, MISep 19, 1976 · N50203 · Substantial damage NTSB OAK76DVA89Accident · No injuriesClosedCessna 150L · Visalia, CASep 14, 1976 · N18014 · Substantial damage NTSB IAD76DKM46Accident · No injuriesClosedCessna 150 · Ashville, NCSep 11, 1976 · N50261 · Substantial damage NTSB FTW76FRF46Accident · No injuriesClosedCessna 150 · Lufkin, TXSep 11, 1976 · N61313 · Substantial damage NTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PASep 6, 1976 · N60753 · Destroyed NTSB MKC76DER96Accident · No injuriesClosedCessna 150 · Cambridge, MNSep 6, 1976 · N16078 · Substantial damage NTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GASep 6, 1976 · N45256 · Substantial damage NTSB CHI76DEV66Accident · No injuriesClosedCessna 150 · Eldorado, ILSep 5, 1976 · N50250 · Substantial damage NTSB CHI76DBM56Accident · No injuriesClosedCessna 150 · Chesaning, MISep 5, 1976 · N16109 · Substantial damage NTSB SEA76DYIIOAccident · No injuriesClosedCessna 150 · Roseburg, ORSep 2, 1976 · N11758 · Substantial damage NTSB OAK76FVM46Accident · No injuriesClosedTaylorcraft F-19 · Santa Cruz, CAAug 29, 1976 · N3579T · Substantial damage NTSB OAK76FVH05Accident · No injuriesClosedCessna 150 · Elk Grove, CAAug 21, 1976 · N9289U · Substantial damage NTSB OAK76DVH07Accident · No injuriesClosedCessna 150 · Paradise, CAAug 21, 1976 · N60001 · Substantial damage NTSB LAX76DUG68Accident · No injuriesClosedCessna 150J · El Monte, CAAug 21, 1976 · N50814 · Substantial damage NTSB CHI76FEA48Accident · No injuriesClosedCessna 150L · Greenwood, INAug 21, 1976 · N6956G · Substantial damage NTSB NYC76FNE32Accident · No injuriesClosedCessna 150 · Ellington, CTAug 16, 1976 · N6272G · Substantial damage NTSB CHI76FET47Accident · No injuriesClosedCessna 150H · Gary, INAug 15, 1976 · N50189 · Substantial damage NTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSAug 7, 1976 · N19443 · Substantial damage NTSB MKC76DCQ74Accident · No injuriesClosedCessna 150 · Clay Center, KSAug 6, 1976 · N7053S · Substantial damage NTSB NYC76FFJ28Accident · No injuriesClosedCessna 150M · Brockport, NYAug 2, 1976 · N8440U · Substantial damage NTSB SEA77DYE56Accident · No injuriesClosedCessna 150 · Eastsound, WAAug 1, 1976 · N60194 · Destroyed NTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSAug 1, 1976 · N19380 · Substantial damage NTSB MKC76DCD59Accident · No injuriesClosedCessna 150 · Leighton, IAAug 1, 1976 · N19153 · Substantial damage NTSB DEN76DQD31Accident · No injuriesClosedCessna 15OJ · Silver City, NMAug 1, 1976 · N50651 · Destroyed NTSB ANC76DAH57Accident · Minor injuriesClosedCessna 150 · Glennallen, AKAug 1, 1976 · N60386 · Substantial damage NTSB MKC76FER85Accident · No injuriesClosedChampion 7ECA · Westbrook, MNJul 30, 1976 · N2593F · Substantial damage NTSB CHI76FEI38Accident · No injuriesClosedCessna 150 · Cleveland, OHJul 28, 1976 · N9451U · Substantial damage NTSB LAX76FUD11Accident · No injuriesClosedCessna 150 · Compton, CAJul 27, 1976 · N10047 · Substantial damage NTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MAJul 25, 1976 · N6754G · Substantial damage