NTSB investigations: Continental 0-300 series, 1986, FL

4 cases on aircraft whose registry engine model is Continental 0-300 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-300 series, 1986, FL per year, 1964–2026: 142 cases
19647
196511
19667
19676
19686
19696
19705
19715
19724
19736
19751
19761
19774
19783
19791
19801
19812
19821
19842
19853
19864
19871
19883
19901
19911
19931
19944
19952
19961
19971
19986
20001
20011
20021
20032
20042
20054
20061
20071
20104
20111
20131
20152
20161
20172
20181
20201
20211
20222
20255
20261

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\") = 1986
    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 ('17022'))
  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 MIA86LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Kissimmee, FLThe plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the…Jul 11, 1986 · N1448F · Substantial damageNTSB MIA86LA167Accident · No injuriesLimited investigationFinal reportCessna 172 · Windermere, FLAfter leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.…May 26, 1986 · N7850X · Substantial damageNTSB MIA86FA135Accident · Serious injuriesField investigationFinal reportCessna 172D · St. Petersburg, FLWhile on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…Apr 26, 1986 · N2321U · Substantial damageNTSB MIA86LA089Accident · No injuriesLimited investigationFinal reportCessna 172G · New Smyrna, FLThe flt had been cruising on the right fuel tank. During the descent, carb heat and rich mixture was selected. The eng quit and the plt selected both fuel tanks. Eng pwr was restored briefly during the descent, but not enough to sustain flt. A forced landing…Mar 2, 1986 · N3870L · Substantial damage