NTSB investigations: Continental 0-200 series, LA
80 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\" = 'LA' 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" = 'LA' 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 FTW73FRJ11Accident · No injuriesClosedCessna 150 · Natchitoches, LANTSB FTW72DRJ30Accident · No injuriesClosedCessna 150 · Frierson, LANTSB FTW71FRJ20Accident · No injuriesClosedCessna 150J · Ruston, LANTSB FTW71DRD08Accident · No injuriesClosedCessna 150 · Houma, LANTSB FTW70DRD19Accident · No injuriesClosedCessna 150 · Crowley, LANTSB FTW70DRJ04Accident · No injuriesClosedCessna 150 · Rayville, LANTSB FTW70D0216Accident · No injuriesClosedCessna 150 · Eunice, LANTSB FTW70D0084Accident · No injuriesClosedCessna 150 · Natchitoches, LANTSB FTW69D0408Accident · No injuriesClosedCessna 150 · Ruston, LANTSB FTW69F0361Accident · No injuriesClosedCessna 150H · Ruston, LANTSB FTW69F0326Accident · No injuriesClosedCessna 150F · New Orleans, LANTSB FTW69F0306Accident · No injuriesClosedCessna 150F · Alexandria, LANTSB FTW68D0601Accident · No injuriesClosedCessna 150 · Lafayette, LANTSB FTW68D0580Accident · No injuriesClosedCessna 150 · Baton Rouge, LANTSB FTW68F0490Accident · Minor injuriesClosedCessna 150 · Walker, LANTSB FTW68F0400Accident · No injuriesClosedCessna 15OF · Alexandria, LANTSB FTW68D0284Accident · No injuriesClosedCessna 150 · Baton Rouge, LANTSB FTW68F0240Accident · No injuriesClosedCessna 150 · Westwego, LANTSB FTW67F0019Accident · No injuriesClosedCessna 150 · Houma, LANTSB FTW67F1004Accident · Serious injuriesClosedCessna 150 · Kentwood, LANTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LANTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LANTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LANTSB FTW67F0025Accident · Serious injuriesClosedCessna 150 · Bogalusa, LANTSB FTW66D0650Accident · Minor injuriesClosedCessna 150 · Hammod, LANTSB FTW66D0549Accident · No injuriesClosedCessna 150 · Slidell, LANTSB FTW66F0461Accident · Minor injuriesClosedCessna 150E · Florriessant, LANTSB FTW66F0414Accident · No injuriesClosedCessna 150 · Shreveport, LANTSB FTW66F0312Accident · Serious injuriesClosedCessna 150 · Westwego, LANTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LA