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.

NTSB FTW73FRJ11Accident · No injuriesClosedCessna 150 · Natchitoches, LAAug 10, 1972 · N1630Q · 2 aircraft · Substantial damageNTSB FTW72DRJ30Accident · No injuriesClosedCessna 150 · Frierson, LAJun 7, 1972 · N6427G · Substantial damageNTSB FTW71FRJ20Accident · No injuriesClosedCessna 150J · Ruston, LAOct 29, 1970 · N50503 · Substantial damageNTSB FTW71DRD08Accident · No injuriesClosedCessna 150 · Houma, LAAug 10, 1970 · N8435M · Substantial damageNTSB FTW70DRD19Accident · No injuriesClosedCessna 150 · Crowley, LAApr 10, 1970 · N7148C · Substantial damageNTSB FTW70DRJ04Accident · No injuriesClosedCessna 150 · Rayville, LAMar 18, 1970 · N8788G · Substantial damageNTSB FTW70D0216Accident · No injuriesClosedCessna 150 · Eunice, LASep 18, 1969 · N2089Z · Substantial damageNTSB FTW70D0084Accident · No injuriesClosedCessna 150 · Natchitoches, LAMay 28, 1969 · N8631S · Substantial damageNTSB FTW69D0408Accident · No injuriesClosedCessna 150 · Ruston, LAMar 5, 1969 · N8430J · Substantial damageNTSB FTW69F0361Accident · No injuriesClosedCessna 150H · Ruston, LAJan 22, 1969 · N23439 · Substantial damageNTSB FTW69F0326Accident · No injuriesClosedCessna 150F · New Orleans, LADec 14, 1968 · N3521L · Substantial damageNTSB FTW69F0306Accident · No injuriesClosedCessna 150F · Alexandria, LANov 23, 1968 · N8092S · Substantial damageNTSB FTW68D0601Accident · No injuriesClosedCessna 150 · Lafayette, LAJun 3, 1968 · N3239X · Substantial damageNTSB FTW68D0580Accident · No injuriesClosedCessna 150 · Baton Rouge, LAMay 4, 1968 · N6405F · Substantial damageNTSB FTW68F0490Accident · Minor injuriesClosedCessna 150 · Walker, LAMar 30, 1968 · N3412J · Substantial damageNTSB FTW68F0400Accident · No injuriesClosedCessna 15OF · Alexandria, LADec 18, 1967 · N8697S · Substantial damageNTSB FTW68D0284Accident · No injuriesClosedCessna 150 · Baton Rouge, LAOct 17, 1967 · N6569F · Substantial damageNTSB FTW68F0240Accident · No injuriesClosedCessna 150 · Westwego, LASep 24, 1967 · N8459G · Substantial damageNTSB FTW67F0019Accident · No injuriesClosedCessna 150 · Houma, LAJun 19, 1967 · N7150F · Substantial damageNTSB FTW67F1004Accident · Serious injuriesClosedCessna 150 · Kentwood, LAApr 30, 1967 · N7710F · DestroyedNTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LASep 1, 1966 · N6585F · Substantial damageNTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LAAug 16, 1966 · N8459G · Substantial damageNTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LAJul 16, 1966 · N8457G · Substantial damageNTSB FTW67F0025Accident · Serious injuriesClosedCessna 150 · Bogalusa, LAJun 25, 1966 · N8036S · Substantial damageNTSB FTW66D0650Accident · Minor injuriesClosedCessna 150 · Hammod, LAMay 1, 1966 · N6595F · DestroyedNTSB FTW66D0549Accident · No injuriesClosedCessna 150 · Slidell, LAMar 1, 1966 · N3521L · Substantial damageNTSB FTW66F0461Accident · Minor injuriesClosedCessna 150E · Florriessant, LADec 24, 1965 · N3059J · Substantial damageNTSB FTW66F0414Accident · No injuriesClosedCessna 150 · Shreveport, LADec 12, 1965 · N8897S · Substantial damageNTSB FTW66F0312Accident · Serious injuriesClosedCessna 150 · Westwego, LASep 23, 1965 · N4323U · Substantial damageNTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LAAug 23, 1964 · N377E · No damage