Fatal NTSB investigations: Continental A&C65 series, LA
6 cases on aircraft whose registry engine model is Continental A&C65 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 per year
| 1969 | 1 |
|---|---|
| 1973 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
Where
Open the mapLatest cases
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
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 FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.NTSB FTW87FA223Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenwood, LAThe pilot touched down briefly in a small clearing which he had prevously driven to by automobile. He then lifted off and started a climbout. Two separate electrical power lines were located just inside a tree line which was very close to the previously…NTSB FTW85FA094Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Ferriday, LAAcft was observed in slow flt aprx 40 ft AGL just above stall speed with the eng operating smoothly. The acft then stalled and impacted in an aprx 90 deg nose down attitude. The plt was flying from the front seat. The acft was not equipped with shoulder…NTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANTSB FTW73AF070Accident · 1 fatalClosedLuscombe 8A · Ama, LANTSB FTW69A0087Accident · 2 fatalClosedPiper J3C-65 · Gurley, LA