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 SEA68D0225Accident · No injuriesClosedCessna 150 · Renton, WANov 22, 1967 · N6849F · 2 aircraft · Substantial damage NTSB NYC68D0361Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYNov 21, 1967 · N972MA · Substantial damage NTSB FTW68D0354Accident · No injuriesClosedCessna 150 · Sand Springs, OKNov 20, 1967 · N3288J · Substantial damage NTSB DIA68D0132Accident · No injuriesClosedCessna 150 · Wyoming, DENov 20, 1967 · N8946S · Substantial damage NTSB MIA68D0365Accident · No injuriesClosedCessna 150G · Enterprise, ALNov 19, 1967 · N6345S · Substantial damage NTSB MKC68D0328Accident · No injuriesClosedCessna 150 · Washington, IANov 17, 1967 · N7799F · Substantial damage NTSB MIA68D0287Accident · No injuriesClosedCessna 150 · Laceys Spring, ALNov 17, 1967 · N8745S · Substantial damage NTSB UNK68X0107Incident · No injuriesClosedCessna 150F · Livermore, CANov 14, 1967 · N6369S · 2 aircraft · Minor damage NTSB MIA68D0288Accident · No injuriesClosedCessna 150 · Lancaster, SCNov 12, 1967 · N2504J · Substantial damage NTSB MIA68D0285Accident · No injuriesClosedCessna 150 · Villa Rica, GANov 11, 1967 · N6254R · Substantial damage NTSB FTW68F0333Accident · No injuriesClosedCessna 150 · Bethany, OKNov 11, 1967 · N8761S · Substantial damage NTSB DEN68D0153Accident · No injuriesClosedCessna 150 · Columbus, NMNov 10, 1967 · N6297R · Substantial damage NTSB CHI68D0504Accident · No injuriesClosedCessna 150 · Mansfield, OHNov 8, 1967 · N6209S · Substantial damage NTSB MKC68D0277Accident · No injuriesClosedCessna 150 · Hamburg, IANov 6, 1967 · N3128J · Substantial damage NTSB NYC68F0282Accident · No injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N8218F · Substantial damage NTSB NYC68F0280Accident · Serious injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N6694F · Substantial damage NTSB FTW68D0328Accident · No injuriesClosedCessna 150G · Rosenberg, TXNov 5, 1967 · N3340J · Substantial damage NTSB MIA68D0304Accident · No injuriesClosedCessna 150 · Davie, FLNov 2, 1967 · N8366J · Substantial damage NTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damage NTSB MIA68D0316Accident · No injuriesClosedCessna 150F · Opa Locka, FLOct 29, 1967 · N8793G · Substantial damage NTSB LAX68F0183Accident · No injuriesClosedCessna 150 · Otay, CAOct 29, 1967 · N6661F · 2 aircraft · Minor damage NTSB DIA68D0117Accident · Minor injuriesClosedCessna 150 · Basye, VAOct 29, 1967 · N7842Z · Substantial damage NTSB OAK68D0181Accident · Minor injuriesClosedCessna 150G · Concord, CAOct 28, 1967 · N4027J · Substantial damage NTSB MIA68D0331Accident · No injuriesClosedCessna 150 · Lithonia, GAOct 28, 1967 · N8122S · Substantial damage NTSB MIA68D0275Accident · No injuriesClosedCessna 150 · Milton, FLOct 28, 1967 · N6615F · Substantial damage NTSB FTW68F0313Accident · No injuriesClosedCessna 150G · Austin, TXOct 28, 1967 · N3737J · Substantial damage NTSB FTW68D0314Accident · No injuriesClosedCessna 150 · Mcallen, TXOct 28, 1967 · N3725J · Substantial damage NTSB OAK68D0182Accident · No injuriesClosedCessna 150 · Agana, GUOct 26, 1967 · N5829E · Substantial damage NTSB NYC68F0277Accident · No injuriesClosedCessna 150 · Bedford, MAOct 25, 1967 · N6588F · Substantial damage NTSB MIA68D0261Accident · No injuriesClosedCessna 150 · Titusville, FLOct 25, 1967 · N8861G · Substantial damage NTSB MIA68D0248Accident · No injuriesClosedCessna 150 · Mccomb, MSOct 23, 1967 · N8846G · Substantial damage NTSB CHI68D0372Accident · No injuriesClosedCessna 150 · Indianapolis, INOct 23, 1967 · N3764J · Substantial damage NTSB NYC68D0276Accident · No injuriesClosedCessna 150 · Newburgh, NYOct 20, 1967 · N7198F · Substantial damage NTSB MKC68F0299Accident · Minor injuriesClosedCessna 150H · Millard, NEOct 18, 1967 · N6549S · Substantial damage NTSB FTW68D0286Accident · No injuriesClosedCessna 150 · Okla. City, OKOct 17, 1967 · N3954U · Substantial damage NTSB FTW68D0284Accident · No injuriesClosedCessna 150 · Baton Rouge, LAOct 17, 1967 · N6569F · Substantial damage NTSB MKC68D0310Accident · No injuriesClosedChampion 7ECA · Caribou, MNOct 15, 1967 · N11040 · Substantial damage NTSB DEN68D0124Accident · Minor injuriesClosedCessna 150 · Casper, WYOct 15, 1967 · N4574U · Substantial damage NTSB DEN68D0111Accident · No injuriesClosedCessna 150 · Pierce, COOct 15, 1967 · N3614J · Substantial damage NTSB CHI68D0390Accident · No injuriesClosedCessna 150 · Streator, ILOct 14, 1967 · N3093S · Substantial damage NTSB FTW68F0282Accident · Minor injuriesClosedCessna 150 · Ferris, TXOct 13, 1967 · N8469J · Destroyed NTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJOct 11, 1967 · N6884F · Destroyed NTSB NYC68F0272Accident · No injuriesClosedCessna 150 · Ballston Spa, NYOct 7, 1967 · N1953Z · Substantial damage NTSB DIA68D0080Accident · No injuriesClosedCessna 150 · New Kent, VAOct 3, 1967 · N6287S · Substantial damage NTSB NYC68F0218Accident · No injuriesClosedCessna 150 · Amityville, NYOct 2, 1967 · N6708F · Substantial damage NTSB DEN68D0118Accident · Minor injuriesClosedCessna 150 · Loveland, COOct 2, 1967 · N3557L · Substantial damage NTSB MKC68F0233Accident · Minor injuriesClosedChampion ECA · Jamestown, NDOct 1, 1967 · N9976Y · Substantial damage NTSB FTW68D0026Accident · No injuriesClosedCessna 150E · Mill Creek, OKSep 30, 1967 · N6251T · Substantial damage NTSB MKC68D0272Accident · No injuriesClosedCessna 150G · Worthington, MNSep 28, 1967 · N3365J · Substantial damage NTSB DEN68D0107Accident · No injuriesClosedCessna 150F · Albuquerque, NMSep 28, 1967 · N8713S · Substantial damage