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 FTW67D0262Accident · No injuriesClosedCessna 150 · Rogers, AROct 15, 1966 · N7852F · Substantial damage NTSB OAK67F0141Accident · No injuriesClosedChampion 7ECA · San Luis Obis, CAOct 14, 1966 · N2561F · Substantial damage NTSB CHI67F0329Accident · No injuriesClosedCessna 150 · Strongsville, OHOct 12, 1966 · N3683J · Substantial damage NTSB NYC67F0318Accident · No injuriesClosedCessna 150F · Greenfield, MAOct 9, 1966 · N6834F · Substantial damage NTSB CHI67D0292Accident · No injuriesClosedChampion 7FC · Hales Corners, WIOct 9, 1966 · N9017B · Substantial damage NTSB CHI67D0276Accident · No injuriesClosedCessna 150 · Grove City, OHOct 9, 1966 · N7872Z · Substantial damage NTSB SEA67D0209Accident · No injuriesClosedCessna 150 · Bellvue, WAOct 8, 1966 · N4146U · Substantial damage NTSB OAK67D0110Accident · No injuriesClosedCessna 150 · San Carlos, CAOct 8, 1966 · N7941Z · Substantial damage NTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TNOct 8, 1966 · N8681G · Substantial damage NTSB LAX67D0166Accident · No injuriesClosedCessna 150 · Ocotillo Well, CAOct 8, 1966 · N6220T · Substantial damage NTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILOct 8, 1966 · N3728J · Substantial damage NTSB LAX67F0140Accident · No injuriesClosedCessna 150 · Huntingtn Bch, CAOct 7, 1966 · N6495T · Substantial damage NTSB LAX67D0161Accident · No injuriesClosedCessna 150 · Rialto, CAOct 6, 1966 · N6519F · Substantial damage NTSB DEN67A0026Accident · 1 fatalClosedCessna 150F · Tooele, UTOct 4, 1966 · N7798F · Destroyed NTSB DEN67F0120Accident · No injuriesClosedCessna 150 · Albuquerque, NMOct 3, 1966 · N8228S · Substantial damage NTSB OAK67D0104Accident · No injuriesClosedCessna 150 · San Jose, CAOct 2, 1966 · N5938T · Substantial damage NTSB NYC67F0300Accident · No injuriesClosedCessna 150 · Carlisle, PAOct 2, 1966 · N7834E · Substantial damage NTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILOct 2, 1966 · N3514J · 2 aircraft · Substantial damage NTSB SEA67D0159Accident · Minor injuriesClosedCessna 150 · Avery, IDOct 1, 1966 · N5812E · Destroyed NTSB FTW67D0256Accident · No injuriesClosedCessna 150 · Pearsall, TXOct 1, 1966 · N7249X · Substantial damage NTSB CHI67D0352Accident · No injuriesClosedCessna 150 · La Farge, WIOct 1, 1966 · N7725F · Substantial damage NTSB DEN67D0149Accident · No injuriesClosedCessna 150 · Artesia, COSep 28, 1966 · N5747E · Substantial damage NTSB MKC67F0272Accident · No injuriesClosedCessna 150 · Rosemount, MNSep 27, 1966 · N6684T · 2 aircraft · Substantial damage NTSB LAX67F0138Accident · No injuriesClosedChampion 7ECA · Capistrano, CASep 24, 1966 · N9567S · Substantial damage NTSB DEN6MD0107Accident · No injuriesClosedCessna 150D · Salt Lake City, UTSep 20, 1966 · N4448U · Substantial damage NTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCSep 18, 1966 · N8680S · Substantial damage NTSB DEN67D0117Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 18, 1966 · N4411U · Substantial damage NTSB OAK67D0162Accident · No injuriesClosedCessna 150 · Las Vegas, NVSep 17, 1966 · N4042U · Substantial damage NTSB FTW67D0203Accident · No injuriesClosedCessna 150 · San Augustine, TXSep 16, 1966 · N3659J · Destroyed NTSB ANC67D0081Accident · No injuriesClosedCessna 150F · Paxson, AKSep 16, 1966 · N8078S · Substantial damage NTSB OAK67D0120Accident · No injuriesClosedCessna 150 · Livermore, CASep 14, 1966 · N6635F · Substantial damage NTSB CHI67F0193Accident · No injuriesClosedCessna 150 · Adrian, MISep 13, 1966 · N6840F · Substantial damage NTSB CHI67D0195Accident · No injuriesClosedCessna 150A · Stevens Point, WISep 12, 1966 · N7217X · Substantial damage NTSB LAX67D0109Accident · Minor injuriesClosedCessna 150 · Banning, CASep 10, 1966 · N7856Z · Substantial damage NTSB CHI67D0273Accident · No injuriesClosedCessna 150 · Middle Bass, OHSep 10, 1966 · N4734X · Destroyed NTSB OAK67D0103Accident · No injuriesClosedCessna 150 · Fresno, CASep 7, 1966 · N7742E · Substantial damage NTSB LAX67F0105Accident · Serious injuriesClosedCessna 150 · Adamana, AZSep 7, 1966 · N3680J · Destroyed NTSB MKC67D0223Accident · No injuriesClosedCessna 150 · Sedalia, MOSep 5, 1966 · N7927F · Substantial damage NTSB LAX67D0127Accident · No injuriesClosedChampion 7ECA · Sierra Vista, AZSep 4, 1966 · N2583F · Substantial damage NTSB MKC67F0214Accident · No injuriesClosedCessna 150 · Cross Lake, MNSep 3, 1966 · N8834G · Substantial damage NTSB FTW67F0193Accident · No injuriesClosedCessna 150 · Friendswood, TXSep 1, 1966 · N8173S · Substantial damage NTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LASep 1, 1966 · N6585F · Substantial damage NTSB FTW67F0208Accident · No injuriesClosedCessna 150 · Austin, TXAug 31, 1966 · N6626F · Substantial damage NTSB ANC67F0044Accident · No injuriesClosedCessna 150F · Anchorage, AKAug 30, 1966 · N8805S · Substantial damage NTSB OAK67F0258Accident · No injuriesClosedN American P-51D · San Jose, CAAug 28, 1966 · N6302T · 2 aircraft · Substantial damage NTSB NYC67D0170Accident · No injuriesClosedCessna 150 · Westford, CTAug 28, 1966 · N7169X · Substantial damage NTSB MIA67D0204Accident · No injuriesClosedCessna 150 · Plains, GAAug 28, 1966 · N6924F · Substantial damage NTSB CHI67D0220Accident · No injuriesClosedCessna 150 · Joliet, ILAug 27, 1966 · N6630F · Substantial damage NTSB SEA67F0115Accident · No injuriesClosedCessna 150 · Roseburg, ORAug 25, 1966 · N6533F · Substantial damage NTSB NYC67D0231Accident · No injuriesClosedCessna 150 · Monticello, NYAug 25, 1966 · N8266F · Substantial damage