NTSB investigations: Continental 0-200 series, 1981, CA

15 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, 1981, CA per year, 1964–2026: 793 cases
196420
196524
196646
196749
196850
196945
197042
197138
197229
197323
197434
197525
197628
197727
197826
197923
198016
198115
198210
198311
198413
198511
198612
19879
198811
19898
19909
19914
19926
199310
19944
19958
19966
19974
19985
19996
20007
200111
20022
20032
20041
20058
20064
20073
20083
20093
20113
20124
20132
20151
20161
20173
20184
20194
20203
20217
20226
20254

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\") = 1981
    AND c.\"eventStateOrRegion\" = 'CA' 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 LAX82DVM07Accident · No injuriesClosedCessna 150 · Ipomo, CADec 27, 1981 · N50528 · Substantial damageNTSB LAX82FUA07Accident · No injuriesClosedCessna 150 · Laguna Beach, CADec 12, 1981 · N8193V · Substantial damageNTSB LAX82FA025Accident · 2 fatalClosedCessna 150M · Antioch, CADec 8, 1981 · N704XM · DestroyedNTSB LAX81FA132Accident · 1 fatalClosedCessna 150 · Hemet, CASep 26, 1981 · N6277G · DestroyedNTSB LAX81FUA15Accident · Minor injuriesClosedCessna 150L · Fullerton, CASep 23, 1981 · N21989 · Substantial damageNTSB LAX81DVG64Accident · No injuriesClosedAeronca 7CCM · Jackson, CAAug 27, 1981 · N84669 · Substantial damageNTSB LAX81FVD33Accident · No injuriesClosedCessna 140 · San Rafael, CAJul 19, 1981 · N110V · Substantial damageNTSB LAX81FVG50Accident · No injuriesClosedCessna 150 · Georgetown, CAJul 5, 1981 · N22456 · Substantial damageNTSB LAX81FA099Accident · 3 fatalClosedPiper PA-28 · Sherman Oaks, CAJun 24, 1981 · N4510K · 2 aircraft · DestroyedNTSB LAX81DUQ19Accident · No injuriesClosedCessna 150 · Inyokern, CAApr 30, 1981 · N6254K · Substantial damageNTSB LAX81DVA34Accident · No injuriesClosedCessna 150M · Planada, CAApr 14, 1981 · N3382V · Substantial damageNTSB LAX81FUG15Accident · Minor injuriesClosedCessna 150G · Victorville, CAMar 3, 1981 · N164LA · Substantial damageNTSB LAX81DUG18Accident · No injuriesClosedCessna 150 · Corona, CAMar 2, 1981 · N9375U · DestroyedNTSB LAX81FVD12Accident · No injuriesClosedCessna 150 · Tracy, CAFeb 21, 1981 · N2021Z · Substantial damageNTSB LAX81DUG12Accident · Minor injuriesClosedVarieze II · Chino, CAFeb 7, 1981 · N78AL · Substantial damage