NTSB investigations: Continental 0-200 series, 1968, FL

20 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.

Cases per year

19642026
NTSB investigations: Continental 0-200 series, 1968, FL per year, 1964–2026: 368 cases
19642
196511
196617
196724
196820
196914
197012
197111
197212
197313
197417
197521
19766
197715
19789
19797
19809
19818
19822
19833
19841
19853
19866
19875
19885
19895
19906
19915
19923
19935
19947
19954
19966
19977
19986
19992
20004
20013
20026
20031
20043
20065
20074
20081
20092
20105
20114
20122
20154
20191
20215
20221
20231
20243
20251
20263

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1968
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND 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.

NTSB MIA69D0297Accident · No injuriesClosedCessna 150H · Ft Lauderdale, FLDec 27, 1968 · N22448 · Substantial damageNTSB MIA69D0285Accident · No injuriesClosedCessna 150H · Flamingo, FLNov 29, 1968 · N6540S · Substantial damageNTSB MIA69D0239Accident · No injuriesClosedCessna 150 · Pensacola, FLNov 28, 1968 · N8335J · Substantial damageNTSB MIA69F0279Accident · No injuriesClosedCessna 150F · West Hollywod, FLNov 23, 1968 · N3081X · Substantial damageNTSB MIA69F0266Accident · No injuriesClosedCessna 150G · Opa Locka, FLNov 20, 1968 · N4636X · Substantial damageNTSB MIA69D0265Accident · No injuriesClosedCessna 150 · W Palm Beach, FLNov 18, 1968 · N3742J · Substantial damageNTSB UNK69X0100Accident · No injuriesClosedCessna 150 · Homestead, FLNov 1, 1968 · N4650X · Substantial damageNTSB MIA69F0143Accident · No injuriesClosedCessna 150 · St.Augustine, FLAug 17, 1968 · N6518T · Substantial damageNTSB MIA69D0178Accident · No injuriesClosedCessna 150 · Crestview, FLJul 20, 1968 · N6345S · Substantial damageNTSB MIA68A0111Accident · 2 fatalClosedCessna 150G · Miami, FLJun 30, 1968 · N6247S · DestroyedNTSB MIA69D0037Accident · No injuriesClosedCessna 150 · Ft.Lauderdale, FLJun 14, 1968 · N8369J · Substantial damageNTSB MIA68F0547Accident · No injuriesClosedCessna 150 · W.Hollywood, FLMay 17, 1968 · N7134F · Substantial damageNTSB MIA69F0003Accident · No injuriesClosedCessna 150 · Merritt Is., FLMay 8, 1968 · N22335 · Substantial damageNTSB MIA68F0496Accident · Serious injuriesClosedCessna 150 · Ocoee, FLApr 9, 1968 · N8457G · DestroyedNTSB MIA68D0483Accident · No injuriesClosedCessna 150G · Davie, FLApr 3, 1968 · N4830X · Substantial damageNTSB MIA68D0504Accident · No injuriesClosedCessna 150 · W.Hollywood, FLApr 2, 1968 · N6590S · Substantial damageNTSB MIA68F0462Accident · No injuriesClosedCessna 150H · Ft.Lauderdale, FLMar 19, 1968 · N6666S · Substantial damageNTSB MIA68F0459Accident · Minor injuriesClosedPiper PA-28 · Arcadia, FLMar 17, 1968 · N7166R · 2 aircraft · Substantial damageNTSB MIA68F0458Accident · No injuriesClosedCessna 150 · Chuluota, FLMar 17, 1968 · N8275S · Substantial damageNTSB MIA68D0400Accident · No injuriesClosedCessna 150 · Miami, FLJan 19, 1968 · N3940J · 2 aircraft · Substantial damage