NTSB investigations: Continental 0-200 series, TN
94 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\" = 'TN' 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" = 'TN' 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 IAD76II002Incident · No injuriesClosedCessna 150 · Nashville, TNNTSB IAD75FKW19Accident · No injuriesClosedCessna 150 · Crossville, TNNTSB IAD75DKW18Accident · No injuriesClosedCessna 150 · Murfreesboro, TNNTSB IAD75FKW14Accident · No injuriesClosedCessna 150 · Columbia, TNNTSB IAD75FKW09Accident · Serious injuriesClosedCessna 150 · Monterey, TNNTSB IAD75FLT06Accident · No injuriesClosedCessna 150 · Brunswick, TNNTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNNTSB IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNNTSB IAD73DKW01Accident · No injuriesClosedCessna 150D · Dixon Spring, TNNTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNNTSB MIA73FLT07Accident · No injuriesClosedCessna 150K · Memphis, TNNTSB MIA73FLT05Accident · No injuriesClosedCessna 150F · Memphis, TNNTSB MIA72DKW25Accident · No injuriesClosedCessna 150G · Rogersville, TNNTSB MIA72FKW16Accident · No injuriesClosedCessna 150H · Nashville, TNNTSB MIA72DLT03Accident · No injuriesClosedCessna 150 · Millington, TNNTSB MIA71FLT14Accident · Serious injuriesClosedCessna 150 · Memphis, TNNTSB MIA71FKW29Accident · No injuriesClosedCessna 150 · Nashville, TNNTSB MIA71DKW28Accident · No injuriesClosedCessna 150 · Mountain Cty, TNNTSB MIA71DKW22Accident · No injuriesClosedCessna 150 · Whitwell, TNNTSB MIA71FKW16Accident · No injuriesClosedCessna 150 · Lafollette, TNNTSB MIA71FKD06Accident · Serious injuriesClosedCessna 150C · Memphis, TNNTSB MIA70DKW13Accident · No injuriesClosedCessna 150 · Robbins, TNNTSB MIA70DKW07Accident · No injuriesClosedCessna 150 · Madisonville, TNNTSB MIA70FKW06Accident · Serious injuriesClosedCessna 150 · Chattanooga, TNNTSB MIA70D0270Accident · Minor injuriesClosedCessna 150 · Spring City, TNNTSB MIA70D0234Accident · No injuriesClosedCessna 150G · Cookeville, TNNTSB MIA70F0135Accident · No injuriesClosedCessna 150 · Knoxville, TNNTSB MIA70D0124Accident · No injuriesClosedCessna 150 · Murfreesboro, TNNTSB MIA70D0061Accident · No injuriesClosedCessna 150 · Lobelville, TNNTSB MIA69F0439Accident · No injuriesClosedCessna 150 · Wrigley, TNNTSB MIA69F0423Accident · No injuriesClosedCessna 150E · Cumingsville, TNNTSB MIA69D0091Accident · No injuriesClosedCessna 150 · Lebanon, TNNTSB MIA69A0006Accident · 1 fatalClosedCessna 150 · Woodbury, TNNTSB MIA68F0525Accident · No injuriesClosedCessna 150 · Donelson, TNNTSB MIA68D0539Accident · No injuriesClosedCessna 150 · Gallatin, TNNTSB MIA68F0100Accident · No injuriesClosedChampion 7FC · Columbia, TNNTSB MIA68D0075Accident · No injuriesClosedCessna 150 · Clarksville, TNNTSB MIA67F0574Accident · No injuriesClosedCessna 150 · Springfield, TNNTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TNNTSB MIA66D0062Accident · No injuriesClosedCessna 150D · Columbia, TNNTSB UNK64X3299Accident · No injuriesClosedCessna 150 · Columbia, TNNTSB UNK64X1771Accident · No injuriesClosedCessna 150 · Clarkrange, TNNTSB UNK64X0114Accident · No injuriesClosedCessna 150 · Powell, TN