Skip to content

Continental A80 series

NTSB investigations · 19

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.engine_model_code IN ('17006') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.engine_model_code IN ('17006')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('17006')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN18LA307Accident · No injuriesLimited investigationFinal reportGerald Dan Coppock Bade-E · Escanaba, MIThe loss of control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in a ground loop and runway excursion.Aug 2, 2018 · N142NV · Substantial damage NTSB ERA12LA410Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlantic Ocean (Atlantic Ocean)A loss of engine power for reasons that could not be determined because the aircraft sank after ditching and was not recovered.Jun 22, 2012 · N40985 · Substantial damage NTSB LAX05LA009Accident · 1 fatalLimited investigationFinal reportBrackett And Peltz Kit Fox III · Aguila, AZthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall. The nature and scope of the problem reported by the pilot is undetermined.Oct 15, 2004 · N543BP · Substantial damage NTSB CHI03LA228Accident · Minor injuriesLimited investigationFinal reportFerence Varieze · Macomb, MIThe pilot's failure to secure the window canopy before takeoff and his failure to maintain directional control which resulted in a loss of control. The pilot's diverted attention is a contributing factor.Jul 26, 2003 · N617JF · Substantial damage NTSB ATL02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pahokee, FLThe loss of engine power and the post-landing fire for undetermined reasons.Apr 11, 2002 · N30660 · Destroyed NTSB LAX01LA296Accident · No injuriesLimited investigationFinal reportFunk C · Merced, CAThe pilot's improper modification of the airplane when he switched a nonvented fuel cap to the fuselage tank. A factor was the inadequate annual inspection.Aug 31, 2001 · N22694 · Substantial damage NTSB ANC87LA072Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Soldotna, AKThe 280 hour private pilot was observed doing steeply banked turns in excess of 90 degrees, inside loops and other aerobatic maneuvers, prior to entering a spin at an estimated altitude of 1500 to 2000 feet. The airplane completed approximately 8 turns prior…May 25, 1987 · N96857 · Substantial damage NTSB CHI85LA271Accident · No injuriesLimited investigationFinal reportJodel D-11 · Wooster, OHThe pilot and pax were on a x-country pleasure flt. After 2420 hrs of fliht, 45 mi short of dest, the engine stopped the acft was ld in a corn fld. Examination disclosed main bearing failure.Jul 6, 1985 · N4628S · Substantial damage NTSB CHI77FEX26Accident · No injuriesClosedJodel D11 · Tell City, INMay 14, 1977 · N4628S · Substantial damage NTSB FTW76FPG71Accident · Serious injuriesClosedBuhl LA-1 · Jacksonville, ARJun 27, 1976 · N368Y · Substantial damage NTSB CHI72FEE22Accident · No injuriesClosedStinson 108 · West Chicago, ILSep 7, 1971 · N26448 · Substantial damage NTSB NYC70FFM17Accident · No injuriesClosedStinson 10 · Westfield, MAJun 23, 1970 · N27762 · Substantial damage NTSB OAK70DVG20Accident · No injuriesClosedFreet BF-1 · Rancho Cordva, CAMay 31, 1970 · N11DF · Substantial damage NTSB MIA70D0098Accident · Serious injuriesClosedCessna 120 · Sarasota, FLJul 12, 1969 · N2963N · Substantial damage NTSB CHI70D0031Accident · No injuriesClosedStinson 10A · Crystal Lake, ILMay 30, 1969 · N26448 · Substantial damage NTSB MKC68F0395Accident · No injuriesClosedStinson 10 · Grimes, IADec 28, 1967 · N26290 · Substantial damage NTSB FTW68F0157Accident · No injuriesClosedLuscombe 8C · Norman, OKAug 22, 1967 · N2863K · Substantial damage NTSB LAX66F0195Accident · Serious injuriesClosedWelsh Rabit · Chino, CANov 30, 1965 · N3599G · Destroyed NTSB UNK64X1076Accident · No injuriesClosedLuscombe 8C · Angleton, TXMar 28, 1964 · N2863K · Substantial damage

Back to Continental A80 series