NTSB investigations: Continental 0-200 series, PA

150 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, newest first

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 c.\"eventStateOrRegion\" = 'PA' 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 NYC80FGM24Accident · No injuriesClosedCessna 150 · New Castle, PAJun 14, 1980 · N22856 · Substantial damageNTSB NYC80FGM19Accident · No injuriesClosedCessna 150 · Everett, PAMay 19, 1980 · N18067 · Substantial damageNTSB NYC80FGM10Accident · No injuriesClosedCessna 150M · Waynesburg, PAJan 26, 1980 · N704ST · Substantial damageNTSB NYC79FGT21Accident · No injuriesClosedCessna 150 · Atglen, PASep 15, 1979 · N2876V · Substantial damageNTSB NYC79FGM35Accident · No injuriesClosedCessna 150 · Zelienople, PAJul 17, 1979 · N19138 · Substantial damageNTSB NYC79FHA16Accident · No injuriesClosedCessna 150G · Slatington, PAJul 1, 1979 · N8397J · Substantial damageNTSB NYC79FGM30Accident · No injuriesClosedCessna 150 · Kittanning, PAJun 27, 1979 · N18077 · Substantial damageNTSB NYC79FGM28Accident · No injuriesClosedCessna 150 · Waterford, PAMay 31, 1979 · N21974 · Substantial damageNTSB NYC79FGM36Accident · No injuriesClosedCessna 150 · Northeast, PAApr 25, 1979 · N6474G · Substantial damageNTSB NYC79FGM15Accident · No injuriesClosedCessna 150 · Belle Vernon, PAFeb 11, 1979 · N9377U · Substantial damageNTSB NYC78FGM45Accident · No injuriesClosedCessna 150 · Franklin, PAAug 17, 1978 · N10687 · Substantial damageNTSB NYC78FGT11Accident · No injuriesClosedVari-Eze 1 · Lewisberry, PAJul 7, 1978 · N886 · Substantial damageNTSB NYC78FA049Accident · Serious injuriesClosedCessna 150M · West Chester, PAMay 7, 1978 · N63176 · DestroyedNTSB NYC78FGT03Accident · No injuriesClosedCessna 150K · Bloomsburg, PAFeb 11, 1978 · N5915J · Substantial damageNTSB NYC77DHD31Accident · No injuriesClosedCessna 150 · Blue Bell, PASep 12, 1977 · N63176 · Substantial damageNTSB NYC77FHA12Accident · Minor injuriesClosedCessna 150 · Honesdale, PAJan 21, 1977 · N22029 · Substantial damageNTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PADec 25, 1976 · N3788J · DestroyedNTSB NYC77DHA06Accident · No injuriesClosedChampion 7ECA · Dalton, PANov 19, 1976 · N2501F · Substantial damageNTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PASep 6, 1976 · N60753 · DestroyedNTSB NYC76DHA35Accident · No injuriesClosedCessna 150 · Tunkhannock, PAJun 5, 1976 · N3092V · Substantial damageNTSB NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PADec 28, 1975 · N1240Q · 2 aircraft · Substantial damageNTSB NYC76DHD07Accident · No injuriesClosedCessna 150 · West Chester, PADec 20, 1975 · N1410Q · Substantial damageNTSB NYC75DGM34Accident · No injuriesClosedChampion 7FC · Wattsburg, PAApr 27, 1975 · N9860Y · Substantial damageNTSB NYC75FHD41Accident · No injuriesClosedCessna 150M · New London, PAApr 13, 1975 · N3156V · Substantial damageNTSB NYC75FGT14Accident · No injuriesClosedCessna 150 · University Pk, PAMar 18, 1975 · N904PS · Substantial damageNTSB NYC75DGT18Accident · No injuriesClosedCessna 150L · Thomasville, PAFeb 20, 1975 · N16074 · Substantial damageNTSB NYC75FGM23Accident · No injuriesClosedCessna 150 · Pittsburgh, PAFeb 13, 1975 · N7451G · Substantial damageNTSB NYC75DHA03Accident · No injuriesClosedCessna 150 · Gilbertville, PAJul 14, 1974 · N18146 · Substantial damageNTSB NYC75FHD01Accident · No injuriesClosedCessna 150 · Philadelphia, PAJul 6, 1974 · N6953F · Substantial damageNTSB NYC74FGM33Accident · No injuriesClosedCessna 150K · Ohiopyle, PAMay 26, 1974 · N5714G · DestroyedNTSB NYC74FGM32Accident · No injuriesClosedCessna 150 · Belle Vernon, PAMay 18, 1974 · N4565U · Substantial damageNTSB NYC74DGT17Accident · No injuriesClosedCessna 150 · University Pk, PAFeb 26, 1974 · N1931Z · Substantial damageNTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANov 20, 1973 · N461NC · 2 aircraft · DestroyedNTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PAJun 2, 1973 · N3203J · Substantial damageNTSB NYC73DGM24Accident · No injuriesClosedCessna 150 · Franklin, PAApr 6, 1973 · N6400G · Substantial damageNTSB NYC73FGM22Accident · No injuriesClosedCessna 150J · Beaver Falls, PAMar 21, 1973 · N60173 · Substantial damageNTSB NYC73FGM20Accident · No injuriesClosedCessna 150J · Belle Vernon, PAMar 20, 1973 · N5582G · Substantial damageNTSB NYC73DGM19Accident · No injuriesClosedCessna 150 · West Mifflin, PAFeb 25, 1973 · N60319 · Substantial damageNTSB NYC73FGM17Accident · No injuriesClosedCessna 150 · West Mifflin, PAFeb 4, 1973 · N61038 · Substantial damageNTSB NYC73DHD12Accident · No injuriesClosedCessna 150 · Ambler, PASep 3, 1972 · N1422Q · DestroyedNTSB NYC73DGM01Accident · No injuriesClosedCessna 150L · Cuddy, PAJul 14, 1972 · N1288Q · Substantial damageNTSB NYC72DGM46Accident · No injuriesClosedCessna 150H · Dubois, PAMay 19, 1972 · N23156 · Substantial damageNTSB NYC72FGM39Accident · No injuriesClosedCessna 150H · Butler, PAApr 8, 1972 · N23210 · Substantial damageNTSB NYC72FGM30Accident · No injuriesClosedCessna 150 · Monroeville, PAJan 26, 1972 · N8716S · Substantial damageNTSB NYC72DGM15Accident · No injuriesClosedCessna 150 · Eighty Four, PASep 5, 1971 · N61038 · Substantial damageNTSB NYC72FGT02Accident · No injuriesClosedCessna 150J · Dallastown, PAAug 17, 1971 · N5597G · Substantial damageNTSB NYC71FGM52Accident · Minor injuriesClosedCessna 150J · Beaver Falls, PAJun 12, 1971 · N50840 · Substantial damageNTSB NYC71FGM46Accident · Minor injuriesClosedCessna 150F · Monroeville, PAMay 16, 1971 · N8562G · Substantial damageNTSB NYC71FGM38Accident · No injuriesClosedCessna 150 · West Mifflin, PAApr 13, 1971 · N61038 · Substantial damageNTSB NYC71DHA35Accident · No injuriesClosedCessna 150 · Honesdale, PAFeb 28, 1971 · N6481T · Substantial damage