NTSB investigations: Continental C145 series, AR
15 cases on aircraft whose registry engine model is Continental C145 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2017 | 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\" = 'AR' 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 ('17012'))
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" = 'AR' 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 ('17012'))
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 GAA17CA399Accident · No injuriesData collectionFinal reportCessna 170B · Pine Bluff, ARThe pilot’s failure to maintain directional control during the landing roll.NTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.NTSB FTW00LA229Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Pettigrew, ARthe pilot's failure to maintain obstacle clearance during landing.NTSB FTW99LA117Accident · No injuriesLimited investigationFinal reportCessna 170B · Fayetteville, ARThe pilot's failure to obtain the proper climb rate resulting in an inadvertent stall. Factors were the rising terrain and the variable winds.NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).NTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.NTSB MKC89LA030Accident · No injuriesLimited investigationFinal reportCessna 170A · Mccrory, ARThe student pilot and passenger said after about 10 minutes of local flight, they experienced a partial power loss. An emergency ldg was attempted on a near by rural strip, but the plt said he had excess airspeed and was unable to land successfully. The…NTSB MKC84LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Jasper, ARThe plt landed the acft on private property to visit relatives. During the landing the acft groundlooped and collapsed the left main landing gear. The plt reported that the winds were from 290 degrees at 18 KTS and gusty. Rugged terrain surrounded the area of…NTSB FTW77DPG07Accident · Minor injuriesClosedGlobe GC-1B · Blythville, ARNTSB FTW73FPG57Accident · No injuriesClosedCessna 170A · Conway, ARNTSB FTW71FPG45Accident · No injuriesClosedCessna 170 · Jonesboro, ARNTSB FTW69D0148Accident · No injuriesClosedCessna 170 · Hot Springs, ARNTSB FTW68D0140Accident · Minor injuriesClosedCessna 170 · Waldron, ARNTSB FTW66F0554Accident · Minor injuriesClosedCessna 170A · Stuttgart, ARNTSB UNK64X2894Accident · No injuriesClosedCessna 170A · Benton, AR