NTSB investigations: Continental A&C65 series, 1982
9 cases on aircraft whose registry engine model is Continental A&C65 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 9 |
|---|---|
| 1983 | 6 |
| 1984 | 13 |
| 1985 | 12 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 7 |
| 1989 | 7 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 7 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 7 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 10 |
| 2006 | 4 |
| 2007 | 13 |
Where
Latest 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 year(c.\"eventDate\") = 1982
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\" = 260))
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 year(c."eventDate") = 1982
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" = 260))
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 LAX83LA065Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Calistoga, CAInitial information indicated that the acft landed with a quartering tailwind, ground looped & collided with a parked glider. A pilot/operator accident report was not received.NTSB NYC83IA040Incident · No injuriesIncident investigationFinal reportAeronca 11AC · Monticello, NYAs the flight made a three point landing in strong, gusting, left crosswinds, a gust of wind lifted the aircraft's left wing. Directional control was lost and the aircraft departed the right side of the runway. It came to rest at the bottom of a grassy slope…NTSB LAX83LA015Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Ukiah, CAThe pilot began taking off in calm wind conditions. He reported that when he almost reached the airspeed for takeoff, the aircraft veered to the right. Subsequently, the aircraft hit a brush pile and a fence and was damaged.NTSB DEN83LA004Accident · No injuriesLimited investigationFinal reportLuscombe 8A · La Junta, COThe student pilot elected to practice touch-and-go landings on runway 12. He reported that after landing, he began to set the trim and prepare to takeoff, when the tail popped up and he could hear the wind whistling. Reportedly, he applied full power, but the…NTSB LAX82DA350Accident · Minor injuriesFinal reportLuscombe 8E · Ramona, CAThe pilot stated that during takeoff, the aircraft tail was raised too soon and that the aircraft torqued left. The aircraft was subsequently lifted off the runway prematurely and stalled.NTSB LAX82DA300Accident · No injuriesFinal reportTaylorcraft DCO-65 · Santa Cruz, CADuring arrival, the pilot entered traffic to land on runway 31 with a wind from 130 deg at 5 KTS. The first approach to land was high, so a go-around was made. On the second approach, the aircraft was low and fast. Reportedly, the aircraft began to veer to…NTSB DEN82DA104Accident · No injuriesFinal reportLuscombe 8A · Wendover, UTThe pilot reported that during the landing roll, he applied moderate braking to avoid a long taxi distance back to the parking area. He was wearing unfamiliar boots with higher than normal heels, and while using the small heel brake peddles, the aircraft…NTSB ATL82DA147Accident · No injuriesFinal reportPiper J3C-65 · Charlotte, NCThe pilot stated that during takeoff roll he turned and reached for a bag that had started to fall out the door. The right wing of the aircraft struck the ground causing the aircraft to turn sideways and collapse the gear.NTSB LAX82IA086Incident · Minor injuriesIncident investigationFinal reportAeronca 11AC · Weldon, CAPilot stated that while at cruise, the engine began running rough and a precautionary landing was executed. During the touchdown, the aircraft struck a bump disconnecting the steering springs. He then lost directional control, striking a tree and fence on the…