Continental A-65-8
NTSB investigations · 22
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('17329')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('17329')
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 ERA21LA084Accident · No injuriesClass 4 · LimitedFinal reportFord Stephen L Super Chief · Blountstown, FLThe pilot's failure to maintain directional control of the airplane during the landing.NTSB GAA17CA447Accident · No injuriesData collectionFinal reportMichael Dean Grissom Grissom Pober Pixie · Louisburg, NCThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA16LA174Accident · No injuriesLimited investigationFinal reportAmerican Champion 7AC · Keene, NHThe disengagement of the tailwheel locking mechanism during the landing roll due to wear, and a subsequent loss of directional control. Contributing was the pilot's inadequate remedial action, which resulted in a runway excursion.NTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…NTSB CEN10CA288Accident · No injuriesData collectionFinal reportMoe-Pietenpol Aircamper A · Early, TXThe pilot's selection of an unsuitable takeoff site.NTSB CEN10CA109Accident · No injuriesData collectionFinal reportSkistmas George Pietnpol Aircamper · Toledo, OHThe pilot's failure to maintain directional control during landing.NTSB ERA09LA182Accident · 1 fatalLimited investigationFinal reportMoore Glenn Moronca · Burgaw, NCA partial loss of engine power due to fuel contamination as a result of the pilot's operation of the airplane with a deteriorated fuel tank.NTSB IAD05LA042Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Andover, NJThe pilot receiving instruction's failure to maintain directional control during the landing roll. Factors in the accident were the flight instructors delayed remedial action, and crosswind.NTSB CHI86LA161Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, MNThe plt was attempting to takeoff from a field when the accident occurred. During takeoff, the acft failed to clear trees at the departure end of the field. The acft contacted the trees and descended to the terrain. The plt had diverted to this field during a…NTSB NYC83LNC02Accident · Serious injuriesFinal reportAeronca 7AC · Johnson Pond, METhe acft lifted off from the surface of Johnson Pond and was climbing over trees when the plt made a sharp turn and the acft struck a tree. The acft then impacted the ground and was destroyed by impact and fire.NTSB DEN81FTM29Accident · No injuriesClosedAeronca 7AC · Provo, UTNTSB NYC78FNC38Accident · Serious injuriesClosedPiper J3F-65 · Houlton, MENTSB NYC78FNE23Accident · No injuriesClosedAeronca 11AC · Fairfield, CTNTSB NYC77FA028Accident · 1 fatalClosedPiper J3C65 · Duanesburg, NYNTSB SEA76FYI24Accident · Minor injuriesClosedPiper J-3 · Salt Crk Falls, ORNTSB NYC73DNC36Accident · Minor injuriesClosedAeronca 7AC · Northeast Hbr, MENTSB DEN72AD036Accident · 1 fatalClosedAeronca 7AC · Pima, AZNTSB MKC71DDM20Accident · No injuriesClosedLuscombe 8B · Northfield, MNNTSB OAK70DVD09Accident · No injuriesClosedLuscombe 8A · Sunol, CANTSB NYC67F0191Accident · Minor injuriesClosedPiper J-3 · West Seneca, NYNTSB NYC65D0123Accident · No injuriesClosedAeronca 7AC · Townsend, DENTSB UNK65X0254Accident · No injuriesClosedPiper J3 · Livingston Mar, NY
Back to Continental A-65-8