NTSB investigations: Continental A&C65 series, 1986
6 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\") = 1986
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") = 1986
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 LAX86LA264Accident · No injuriesLimited investigationFinal reportPiper J-3 · Columbia, CAThe acft nosed over in soft ground during landing roll after veering off rwy 17. The plt indicated that the right brake pedal was jammed by 1/2 inch carpet that had been installed in the acft. The acft veered off the right side of the rwy 17. When the plt…NTSB LAX86LA234Accident · No injuriesLimited investigationFinal reportMooney M-18C · Lakeport, CAThe plt indicated that there was a gusty left crosswind present during landing. The acft drifted right off the 40 ft wide asphalt rwy and collided with a small ditch and dirt bank. The acft then nosed over into the arpt drainage ditch.NTSB ATL86LA106Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hamilton, OHThe plt made a low pass over the drag strip to check the wind. He climbed, made a 180 deg turn and attempted a normal landing. On roll out a wind gust was encountered which tipped the acft up on the right wheel. It veered off the hard surface into a guard…NTSB DEN86LA109Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Santa Teresa, NMThe plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main…NTSB SEA86LA077Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East Sound, WAUpon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground.NTSB MKC86LA067Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Jacksonville, ARThe pilot was attempting a takeoff from a sod strip in an Aeronca tail dragger aircraft in gusty wind conditions. The air strip runway is situated along a north-south heading with the rptd winds fm 290 degrees magnetic at 13 knots with gusts to 18 knots. As…