NTSB investigations: Continental A&C65 series, 1998
7 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\") = 1998
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") = 1998
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 NYC99FA037Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Greenville, PAThe pilot's failure to maintain directional control during touch-and-go landing, and his failure to maintain obstacle clearance. A factor was the tree.NTSB ATL98LA126Accident · No injuriesLimited investigationFinal reportAeronca 65-TAC (L-3) · Dalton, GAThe pilots failure to maintain directional control of the airplane during landing. A factor was the pilot's lack of experience in the same make and model airplane.NTSB CHI98LA232Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Chillicothe, MOthe improper use of the engine starting procedure. Factors contributing to the accident were the pilot in command's lack of recent experience, the aircraft not being tied down, the utility pole and guy wire.NTSB LAX98LA217Accident · No injuriesLimited investigationFinal reportAeronca Chief 65-CA · Phoenix, AZThe failure of the pilot to maintain directional control of the aircraft during the landing rollout.NTSB FTW98LA233Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sheridan, ARThe inadvertent engine start due to the pilot's failure to ensure that the magneto switch was in the OFF position when he was attempting to clear the flooded engine. A factor was the pilot's improper starting procedure, which resulted in flooding the engine.NTSB FTW98LA228Accident · Minor injuriesLimited investigationFinal reportAeronca 65-C · Ozark, ARThe pilot's failure to maintain aircraft control.NTSB SEA98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Bozeman, MTThe pilot's failure to maintain directional control during takeoff.