NTSB investigations: Continental A&C65 series, 1982
5 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 | 5 |
|---|---|
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 4 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 5 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 2 |
| 2007 | 2 |
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\" = 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 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" = 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 CHI82DA333Accident · No injuriesFinal reportPiper J-3C65 · Bloomfield Hill, MITakeoff was from se end of a lake about 4,000 ft long (se to nw) with a small island in the center. The plt stated that after lift-off he obtained climb speed but the acft would not climb from about 20-30 ft above the water. Severe turbulence was encountered…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 ATL82DA237Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Spout Springs, NCThe pilot stated that the wind was gusting and shifting as he was landing with a cumulus build-up nearby. He reported that during his landing, he increased his airspeed to compensate for a gusty crosswind. The pilot stated that the mechanical brakes did not…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…NTSB NYC82DHA08Accident · Serious injuriesFinal reportAeronca 11AC · Beach Lake, PAThe pilot of a ski equipped aircraft began taking off on a 900 ft strip. There was snow on the runway, but grass showed through in places. The pilot reported that the aircraft slowed "very very little" while crossing an area with grass showing. Just beyond…