Fatal NTSB investigations: Continental A&C65 series
18 cases on aircraft whose registry engine model is Continental A&C65 series, where the first occurrence was “In flight collision with object”. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 3 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 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.\"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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 DFW07LA170Accident · 1 fatalLimited investigationFinal reportHazen Fly Baby · Page, OKThe airplane's collision with wooded and mountainous terrain for undetermined reasons.NTSB ATL05LA111Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Yadkinville, NCThe pilots failure to maintain adequate clearance from object and inadequate visual look-out while maneuvering resulted in an in-flight collision with power lines.NTSB LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.NTSB SEA03LA185Accident · 1 fatalLimited investigationFinal reportAeronca 65-CA · Polson, MTThe pilot's failure to maintain clearance from an object while maneuvering and alcohol impairment. Transmission wires, dark night conditions, and drug impairment were factors.NTSB MIA01LA220Accident · 1 fatalLimited investigationFinal reportPiper J-4A · Mosheim, TNThe failure of the student pilot to maintain altitude clearance during a balked landing go-around resulting in the collision with a utility pole, transmission wires, and a ground borne vehicle.NTSB CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.NTSB IAD97LA006Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Springfield, OHfailure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.NTSB MIA96FA148Accident · 1 fatalField investigationFinal reportAeronca O-58B · Greenville, SCthe pilot's failure to maintain adequate altitude/clearance from power lines while maneuvering at a low altitude.NTSB LAX96FA120Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Elk Grove, CAthe pilot's failure to see and avoid the obstruction.NTSB BFO93FA128Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-65 · Danbury, CTUndetermined.NTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.NTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.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 NYC87DHD04Accident · 1 fatalFinal reportMarrone VM-1 · Jobstown, NJThe plt was observed to make a low pass over the arpt, then cont beyond the departure end where the acft flew into a row of trees. Witnesses rprtd the sun was low & that the plt was flying toward the sun. Impact with the trees occurred about 1200 ft from the…NTSB SEA85FA171Accident · 2 fatalField investigationFinal reportPiper J3-C-65 · Goose Prairie, WAThe acft contacted trees while the plt was performing low level passes over a boy scout camp. Witnesses reported the plt made three passes over the camp and during one of those passes, the plt dropped a bag of candy bars to the scouts. The fourth, during…NTSB ATL83FA272Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Ellenwood, GADuring the flt, the acft collided with 2 utility transmission lines, then crashed to the ground. According to witnesses, the accident occurred after the acft had circled the passenger's home & the plt had started a turn. An exam of the wreckage revealed no…NTSB MKC82FCJ05Accident · 1 fatalFinal reportTaylorcraft BC-12-65 · Max, NEPilot flying cross-country at low altitude collided with wires and crashed. No malfunctions of aircraft observed.NTSB NYC82FGT15Accident · 3 fatalFinal reportAeronca 11AC · Peach Bottom, PAThe non-certificated pilot took off with one passenger on board and with both doors removed. Witnesses observed the pilot make a number of passes near boats, under power lines and near people on the surface. A number of witnesses stated the passenger was…