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.
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" DESCRun 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 NYC80FGM24Accident · No injuriesClosedCessna 150 · New Castle, PANTSB NYC80FGM19Accident · No injuriesClosedCessna 150 · Everett, PANTSB NYC80FGM10Accident · No injuriesClosedCessna 150M · Waynesburg, PANTSB NYC79FGT21Accident · No injuriesClosedCessna 150 · Atglen, PANTSB NYC79FGM35Accident · No injuriesClosedCessna 150 · Zelienople, PANTSB NYC79FHA16Accident · No injuriesClosedCessna 150G · Slatington, PANTSB NYC79FGM30Accident · No injuriesClosedCessna 150 · Kittanning, PANTSB NYC79FGM28Accident · No injuriesClosedCessna 150 · Waterford, PANTSB NYC79FGM36Accident · No injuriesClosedCessna 150 · Northeast, PANTSB NYC79FGM15Accident · No injuriesClosedCessna 150 · Belle Vernon, PANTSB NYC78FGM45Accident · No injuriesClosedCessna 150 · Franklin, PANTSB NYC78FGT11Accident · No injuriesClosedVari-Eze 1 · Lewisberry, PANTSB NYC78FA049Accident · Serious injuriesClosedCessna 150M · West Chester, PANTSB NYC78FGT03Accident · No injuriesClosedCessna 150K · Bloomsburg, PANTSB NYC77DHD31Accident · No injuriesClosedCessna 150 · Blue Bell, PANTSB NYC77FHA12Accident · Minor injuriesClosedCessna 150 · Honesdale, PANTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PANTSB NYC77DHA06Accident · No injuriesClosedChampion 7ECA · Dalton, PANTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PANTSB NYC76DHA35Accident · No injuriesClosedCessna 150 · Tunkhannock, PANTSB NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PANTSB NYC76DHD07Accident · No injuriesClosedCessna 150 · West Chester, PANTSB NYC75DGM34Accident · No injuriesClosedChampion 7FC · Wattsburg, PANTSB NYC75FHD41Accident · No injuriesClosedCessna 150M · New London, PANTSB NYC75FGT14Accident · No injuriesClosedCessna 150 · University Pk, PANTSB NYC75DGT18Accident · No injuriesClosedCessna 150L · Thomasville, PANTSB NYC75FGM23Accident · No injuriesClosedCessna 150 · Pittsburgh, PANTSB NYC75DHA03Accident · No injuriesClosedCessna 150 · Gilbertville, PANTSB NYC75FHD01Accident · No injuriesClosedCessna 150 · Philadelphia, PANTSB NYC74FGM33Accident · No injuriesClosedCessna 150K · Ohiopyle, PANTSB NYC74FGM32Accident · No injuriesClosedCessna 150 · Belle Vernon, PANTSB NYC74DGT17Accident · No injuriesClosedCessna 150 · University Pk, PANTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PANTSB NYC73DGM24Accident · No injuriesClosedCessna 150 · Franklin, PANTSB NYC73FGM22Accident · No injuriesClosedCessna 150J · Beaver Falls, PANTSB NYC73FGM20Accident · No injuriesClosedCessna 150J · Belle Vernon, PANTSB NYC73DGM19Accident · No injuriesClosedCessna 150 · West Mifflin, PANTSB NYC73FGM17Accident · No injuriesClosedCessna 150 · West Mifflin, PANTSB NYC73DHD12Accident · No injuriesClosedCessna 150 · Ambler, PANTSB NYC73DGM01Accident · No injuriesClosedCessna 150L · Cuddy, PANTSB NYC72DGM46Accident · No injuriesClosedCessna 150H · Dubois, PANTSB NYC72FGM39Accident · No injuriesClosedCessna 150H · Butler, PANTSB NYC72FGM30Accident · No injuriesClosedCessna 150 · Monroeville, PANTSB NYC72DGM15Accident · No injuriesClosedCessna 150 · Eighty Four, PANTSB NYC72FGT02Accident · No injuriesClosedCessna 150J · Dallastown, PANTSB NYC71FGM52Accident · Minor injuriesClosedCessna 150J · Beaver Falls, PANTSB NYC71FGM46Accident · Minor injuriesClosedCessna 150F · Monroeville, PANTSB NYC71FGM38Accident · No injuriesClosedCessna 150 · West Mifflin, PANTSB NYC71DHA35Accident · No injuriesClosedCessna 150 · Honesdale, PA