NTSB investigations: Continental E185 series
13 cases on aircraft whose registry engine model is Continental E185 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014')
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 ('17014')
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 LAX06LA231Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Beckwourth, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB ATL05CA166Accident · No injuriesData collectionFinal reportBeech 35 · Carthage, NCThe pilot's excessive braking resulting in a loss of control and subsequent impact with gully. A related factor was the tailwind.NTSB IAD05LA082Accident · No injuriesLimited investigationFinal reportBeech C35 · West Milford, NJThe pilot's failure to maintain directional control during landing, which resulted in a collision with a drainage ditch.NTSB SEA05LA015Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Redmond, ORThe student pilot's failure to maintain directional control during the landing roll. Also causal were the instructor's inadequate supervision and remedial action. Factors include soft terrain just off the side of the runway.NTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.NTSB FTW01LA163Accident · No injuriesLimited investigationFinal reportBeech D35 · Houston, TXthe pilot's failure to maintain aircraft control during the takeoff roll.NTSB MIA97LA200Accident · No injuriesLimited investigationFinal reportCessna 150F · Clearwater, FLthe student pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in an on-ground loss of control and subsequent collision with trees and a ditch. The crosswind, trees, and ditch were related factors.NTSB FTW96LA213Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Calhan, COthe pilot's failure to maintain directional control during landing. A factor was a gusting cross-wind.NTSB FTW90LA113Accident · No injuriesLimited investigationFinal reportLuscombe 11 · Fort Worth, TXLoss of control on the ground, due to a locked left brake, undetermined reasons.NTSB FTW89LA126Accident · No injuriesLimited investigationFinal reportBeech 35 · Terrell, TXThe pilot's failure to maintain directional control. A factor related to the accident was: the pile of dirt (dirt bank) beside the runway.NTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…NTSB DEN84LA087Accident · No injuriesLimited investigationFinal reportTexas Helicopter 205 · Erie, COThe plt reported that he landed on rwy 15 with a wind from O90 deg at 20 gusting 30 KTS. After touchdown, the acft began veering to the left. The plt applied right rudder & right brake, but the left wheel dropped off the left side of the rwy & went into mud.…