NTSB investigations: Continental O-470 series, 1997
12 cases on aircraft whose registry engine model is Continental O-470 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 | 20 |
|---|---|
| 1983 | 21 |
| 1984 | 11 |
| 1985 | 15 |
| 1986 | 19 |
| 1987 | 15 |
| 1988 | 14 |
| 1989 | 11 |
| 1990 | 17 |
| 1991 | 13 |
| 1992 | 11 |
| 1993 | 13 |
| 1994 | 11 |
| 1995 | 14 |
| 1996 | 9 |
| 1997 | 12 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 13 |
| 2001 | 7 |
| 2002 | 13 |
| 2003 | 12 |
| 2004 | 14 |
| 2005 | 11 |
| 2006 | 15 |
| 2007 | 12 |
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 year(c.\"eventDate\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
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 year(c."eventDate") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
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 FTW98LA077Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Worth, TXthe pilot's improper planning/decision, by allowing the airplane to get in a situation, where he could not compensate for wind conditions. A related factor was the gusty crosswind.NTSB FTW98LA020Accident · No injuriesLimited investigationFinal reportCessna 180J · Chama, NMthe pilot's failure to maintain directional control of the airplane during its landing roll. Encounter with an embankment (dirt bank) was a related factor.NTSB LAX97LA306Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bullhead City, AZThe pilot's inadequate compensation for the crosswind,NTSB FTW97LA279Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlisle, ARthe pilot's failure to maintain directional control of the airplane during the takeoff roll (at night).NTSB LAX97LA203Accident · No injuriesLimited investigationFinal reportCessna 180 · Hollister, CAThe pilot's improper use of the elevator and his subsequent failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's application of full power following the loss of directional control, which increased…NTSB SEA97LA127Accident · No injuriesLimited investigationFinal reportCessna 182 · Brigham City, UTfailure of the pilot to maintain proper runway alignment during the landing. The gusty quartering crosswind was a related factor.NTSB MIA97LA153Accident · No injuriesLimited investigationFinal reportCessna 182P · Mobile, ALthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during landing rollout, which resulted in a collision with a runway light.NTSB FTW97LA143Accident · No injuriesLimited investigationFinal reportCessna 180D · Erie, COThe pilot's failure to maintain airplane directional control. A factor was the crosswind.NTSB CHI97LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Kirksville, MOthe pilot failed to adequately compensate for the wind conditions on the runway during landing roll. Factors included the crosswind and gusts.NTSB FTW97LA093Accident · No injuriesLimited investigationFinal reportCessna 180K · Valentine, TXThe pilot's failure to attain the proper touchdown point, and the excessive airspeed during the approach and landing. A factor was the dirt bank paralleling the airstrip.NTSB CHI97LA065Accident · No injuriesLimited investigationFinal reportCessna 182J · Gaylord, MIthe student pilot's inadequate compensation for the wind conditions which resulted in a failure to maintain proper runway alignment. Factors associated with the accident were: the gusty, crosswind condition, the pilot's failure to perform a go-around, and the…NTSB FTW97TA075Accident · No injuriesFinal reportCessna 182Q · Cleburne, TXthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the crosswind, and the dirt bank which was parallel to the runway.