NTSB investigations: Continental A&C75 series, KS
15 cases on aircraft whose registry engine model is Continental A&C75 series. 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
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1982 | 1 |
| 2000 | 1 |
| 2003 | 1 |
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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
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."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
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 CHI03LA165Accident · No injuriesLimited investigationFinal reportEngineering & Research 415-C · Independence, KSA loss of engine power due to fuel starvation. A factor to the accident was the pilot's improper installation of the fuel cap.NTSB CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB MKC82DA172Accident · No injuriesFinal reportErcoupe 415C · Andover, KSPilot reported he was taxiing and turned to avoid animals. Aircraft then collided with a tree. He had given two other versions verbally of how the damage occurred.NTSB MKC76FCQQ1Accident · No injuriesClosedErco 415-C · St Marys, KSNTSB MKC76DCQ67Accident · No injuriesClosedErco 415-C · Derby, KSNTSB MKC76DCQ21Accident · No injuriesClosedGreat Lakes S-BABY · Phillipsburg, KSNTSB MKC74AK055Accident · 2 fatalClosedAeronca 7AC · Colony, KSNTSB MKC70FCG35Accident · Serious injuriesClosedPiper J5A · Vinland, KSNTSB MKC70FCQ21Accident · 1 fatalClosedPiper J3C-65 · Andover, KSNTSB MKC69D0393Accident · No injuriesClosedErco 415-C · Leawood, KSNTSB MKC69D0204Accident · No injuriesClosedErco 415-C · Stilwell, KSNTSB MKC67F0083Accident · No injuriesClosedErcoupe 415-C · Tribune, KSNTSB UNK66X0113Accident · No injuriesClosedErcoupe 415-C · Stafford, KSNTSB MKC65F0150Accident · No injuriesClosedPiper J3 · Leoti, KSNTSB UNK65X1130Accident · No injuriesClosedErcoupe 415C · Phillipsbur, KS