Final NTSB investigations: Continental A-65 series
5 cases on aircraft whose registry engine model is Continental A-65 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
| 1982 | 1 |
|---|---|
| 2012 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17324'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17324'))
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 ERA22LA012Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Winchester, VAThe pilot’s misapplication of brakes during the landing roll which resulted in a nose-over event and substantial damage to the airplane.NTSB CEN20CA191Accident · No injuriesClass 4 · Data collectionFinal reportPietenpol Aircamper · Midland, MIThe pilot's loss of control during an aborted landing.NTSB ERA17FA156Accident · 2 fatalField investigationFinal reportLuscombe 8 · East Windsor, CTThe flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…NTSB LAX82DA092Accident · Minor injuriesFinal reportPiper J3F-65 · Chandler, AZWhile on a downwind leg of the traffic pattern, the pilot noticed a very loud grinding noise as if the engine was coming apart. He stated that the engine RPM became very high. He attempted to maneuver for a landing on the runway but entered a high sink rate.…