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 MIA74DLG22Accident · No injuriesClosedCessna 150 · N Myrtle Bch, SCJan 27, 1974 · N6551F · Substantial damage NTSB IAD74DKM38Accident · No injuriesClosedCessna 150 · Coleridge, NCJan 27, 1974 · N6362G · Substantial damage NTSB IAD74DIJ10Accident · No injuriesClosedCessna 150F · Minerl Wells, WVJan 27, 1974 · N8048S · Substantial damage NTSB MKC74AK040Accident · 2 fatalClosedCessna 150J · Pittsburg, KSJan 25, 1974 · N60544 · Destroyed NTSB IAD74DHD26Accident · Minor injuriesClosedCessna 150 · Cheswold, DEJan 22, 1974 · N18140 · Substantial damage NTSB NYC74FNC36Accident · No injuriesClosedCessna 150 · Eliot, MEJan 20, 1974 · N18585 · Substantial damage NTSB CHI74FEC28Accident · No injuriesClosedCessna 150L · Mason, MIJan 19, 1974 · N16080 · Substantial damage NTSB MKC74DCG19Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 16, 1974 · N6095J · Substantial damage NTSB FTW74FQG39Accident · No injuriesClosedCessna 150F · Amarillo, TXJan 14, 1974 · N222DF · Substantial damage NTSB CHI74DEV34Accident · No injuriesClosedCessna 150 · Pekin, ILJan 14, 1974 · N11570 · Substantial damage NTSB MKC74DER35Accident · No injuriesClosedCessna 150E · Springfield, MNJan 13, 1974 · N4019U · Substantial damage NTSB SEA74DTI16Accident · No injuriesClosedCessna 150 · Hamilton, MTJan 11, 1974 · N4621X · Substantial damage NTSB DEN74DTE47Accident · No injuriesClosedCessna 150 · Greeley, COJan 10, 1974 · N1396Q · Substantial damage NTSB MIA74FKT49Accident · No injuriesClosedPiper PA-30 · Ft Lauderdale, FLJan 8, 1974 · N12BX · 2 aircraft · Substantial damage NTSB CHI74FEG13Accident · No injuriesClosedCessna 150F · Phillipsburg, OHJan 8, 1974 · N7879F · Substantial damage NTSB CHI74DE118Accident · No injuriesClosedCessna 150H · Wadsworth, OHJan 5, 1974 · N22151 · 2 aircraft · Substantial damage NTSB CHI74FEK11Accident · No injuriesClosedCessna 150L · Marion, OHJan 4, 1974 · N19079 · Substantial damage NTSB SEA74FTA15Accident · No injuriesClosedCessna 150 · Belle Creek, MTDec 29, 1973 · N2295J · Substantial damage NTSB FTW74FPM16Accident · No injuriesClosedCessna 150K · Sand Springs, OKDec 26, 1973 · N6032G · No damage NTSB CHI74DEM31Accident · No injuriesClosedCessna 150 · Ludington, MIDec 21, 1973 · N6491F · Substantial damage NTSB CHI74DEE40Accident · No injuriesClosedCessna 150 · Rochelle, ILDec 20, 1973 · N10488 · Substantial damage NTSB OAK74DXQ18Accident · No injuriesClosedCessna 150 · Chester, CADec 18, 1973 · N51135 · Substantial damage NTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damage NTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · Destroyed NTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NEDec 10, 1973 · N11183 · Substantial damage NTSB CHI74DEP24Accident · No injuriesClosedCessna 150 · Crivitz, WIDec 10, 1973 · N10772 · Substantial damage NTSB MIA74FKA07Accident · No injuriesClosedCessna 150 · Humacao, PRDec 9, 1973 · N1707Q · Substantial damage NTSB SEA74DYG21Accident · No injuriesClosedCessna 150 · Priest River, IDDec 2, 1973 · N7711E · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage NTSB CHI74FEV29Accident · No injuriesClosedCessna 150L · Laharpe, ILDec 1, 1973 · N1545Q · Substantial damage NTSB FTW74DPA13Accident · No injuriesClosedCessna 150L · Poynor, TXNov 30, 1973 · N5302Q · Substantial damage NTSB IAD74DKM29Accident · No injuriesClosedCessna 150 · Gastonia, NCNov 22, 1973 · N6314G · Substantial damage NTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANov 20, 1973 · N461NC · 2 aircraft · Destroyed NTSB MIA74DKT39Accident · No injuriesClosedCessna 150 · Clewiston, FLNov 20, 1973 · N5646E · Substantial damage NTSB LAX74FUJ33Accident · No injuriesClosedCessna 150L · Florence, AZNov 20, 1973 · N1613Q · Substantial damage NTSB NYC74FNE12Accident · Minor injuriesClosedCessna 150K · Hartford, CTNov 18, 1973 · N6209G · Substantial damage NTSB MIA74DRT37Accident · No injuriesClosedCessna 150 · Miami, FLNov 8, 1973 · N5292Q · Substantial damage NTSB MKC74DCD20Accident · No injuriesClosedCessna 150 · Waterloo, IANov 4, 1973 · N6328G · Substantial damage NTSB MIA74FLG13Accident · No injuriesClosedCessna 150F · Barnwell, SCNov 4, 1973 · N8297F · Substantial damage NTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNov 3, 1973 · N8561J · Substantial damage NTSB OAK74FVM13Accident · No injuriesClosedCessna 150 · San Carlos, CANov 2, 1973 · N7282S · Substantial damage NTSB OAK74FVA32Accident · No injuriesClosedCessna 150G · Madera, CANov 1, 1973 · N8618J · Substantial damage NTSB NYC74AN039Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 31, 1973 · N2133T · 2 aircraft · Minor damage NTSB OAK74DVD15Accident · No injuriesClosedCessna 150 · Petaluma, CAOct 30, 1973 · N16101 · Destroyed NTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INOct 27, 1973 · N4027J · Substantial damage NTSB ANC74FAG76Accident · No injuriesClosedCessna 150 · Anchorage, AKOct 22, 1973 · N6691T · Substantial damage NTSB LAX74FUA08Accident · No injuriesClosedCessna 150J · El Toro, CAOct 20, 1973 · N51290 · Substantial damage NTSB LAX74FUJ23Accident · Minor injuriesClosedCessna 150E · Sun City, AZOct 14, 1973 · N6231T · Substantial damage NTSB DEN74DQD10Accident · No injuriesClosedCessna 150 · Las Cruces, NMOct 14, 1973 · N22280 · Substantial damage NTSB CHI74FEG09Accident · Serious injuriesClosedCessna 150 · Oxford, OHOct 14, 1973 · N23502 · Substantial damage