NTSB investigations: Continental A&C75 series
13 cases on aircraft whose registry engine model is Continental A&C75 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 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1997 | 2 |
| 2000 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005')
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005')
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 DFW07LA206Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Mason County, TXThe loss of control as result of the collapsed right main landing gear during the landing roll. A contributing factor was the failure of the right main gear as result of corrosion.NTSB CHI07CA175Accident · Minor injuriesData collectionFinal reportLuscombe 8A · London, OHThe pilot's failure to maintain directional control of the airplane and the pilot's inadequate compensation for the crosswind which resulted in a ground loop and subsequent collision with a taxiway sign. Factors contributing to the accident include the…NTSB CHI06LA281Accident · No injuriesLimited investigationFinal reportUnivar Ercoupe · Howell, MIThe student pilot's improper landing flare and lack of total experience.NTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.NTSB LAX97LA323Accident · No injuriesLimited investigationFinal reportNewberg PL-4A · Placerville, CAfailure of the pilot to maintain directional control of the aircraft during the rollout phase of the landing sequence, which resulted in a gound swerve.NTSB SEA97LA197Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elma, WAThe pilot's inadequate compensation for wind conditions while landing. A factor was the crosswind.NTSB ANC93LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-3 · Knik, AKThe improper use of the flight controls by the student pilot and inadequate supervision by the CFI pilot-in-command.NTSB SEA89LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Longbranch, WAThe poor in-flight decision by the pilot to land on water, downwind. His failure to compensate for the wind conditions resulted in a loss of control and nose over of the airplane.NTSB LAX88LA092Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lakeport, CADuring ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less…NTSB LAX88DUQ01Accident · 1 fatalFinal reportStits Elkins 85 · Camarillo, CADuring the starting procedures for a local flight, the pilot had chocked the wheels and was hand-propping the engine. After several tries, the engine started. The airplane jumped the chocks and the pilot moved to the right wing, attempting to stop the…NTSB CHI85LA355Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ashkum, ILThe left wing of the acft contacted crops during an attempted takeoff. The plt reported liftoff was too soon and the acft veered left contacted crops. The plt stated that he should have stayed on rwy longer.NTSB CHI84LA021Accident · No injuriesLimited investigationFinal reportPiper J4E · Troy, MIThe acft departed the side of the rwy during landing and nosed over. A private pilot was being accompanied by a commercial pilot whose CFI cirtificate had expired. During landing roll the private pilot began 's' turns for better forward visibility. The…NTSB ANC82DAG36Accident · No injuriesFinal reportTaylorcraft BC-12D · Settlers Bay, AKWhile on a cross-country flight from wasilla to king lake the pilot decided to do some touch and go landings at Settlers Bay. The pilot stated that on his third landing the left brake locked and the aircraft swerved off the runway into a ditch nosing over.