NTSB investigations: Continental O-470 series, 1982
7 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Overrun”. 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 | 7 |
|---|---|
| 1983 | 10 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 7 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 3 |
Where
Latest 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\") = 1982
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\" = 340))
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") = 1982
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" = 340))
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 FTW82DA298Accident · No injuriesFinal reportCessna 182E · Albuquerque, NMThe pilot stated that after a normal approach, the aircraft touched down at about 90 mph on the first 1/4 to 1/3 of the runway. He raised the flaps and applied brakes. He noticed that there was insufficient braking action to stop on the wet runway, but by the…NTSB FTW82DA278Accident · Minor injuriesFinal reportCessna 182 · Mckinney, TXAfter a normal skydiver drop, the pilot spiraled down for a normal landing on a 2000 ft gravel runway with a powerline at the approach end. The wind was reported as variable at 5 KTS. The pilot reported that during the landing, the aircraft touched down on…NTSB SEA82DA105Accident · No injuriesFinal reportCessna 182Q · Spokane, WAThe pilot reported that after checking the wind sock, an approach was made to the runway over trees. Reportedly, the first approach was uncomfortable, so a go-around was made. The pilot stated that the second approach and touchdown were normal, but there was…NTSB NYC82DA127Accident · No injuriesFinal reportCessna 182H · Fort Fairfield, METhe pilot stated that the aircraft was slow to accelerate in loose gravel at the beginning of the takeoff roll. He reported that he rotated for takeoff before reaching his abort point about 1000 ft down the 2100 ft runway. He stated that the aircraft was not…NTSB ATL82DA133Accident · No injuriesFinal reportCessna 182 · Summersville, WVAccording to the pilot, he made his landing approach high and hot. He touched down long and was unable to stop on the remaining runway. While applying brakes, the aircraft veered off the side of the runway. Subsequently, the nose and right main gear failed.NTSB DEN82DA051Accident · No injuriesFinal reportCessna 182K · St. Ignatius, MTThe pilot stated that he and his passengers attempted to remove as much snow as possible from the aircraft and that he was confident that the propeller blast would blow away whatever snow remained. Although the wind at surrounding stations was generally…NTSB ATL82DA045Accident · No injuriesFinal reportCessna 182L · Conyers, GAThe destination airport is a private strip that is oriented on a 150/330 degree heading. The northwest end is enclosed by tall trees. Accordingly, most landings are made toward the northwest regardless of wind direction. The pilot landed on runway 33 which…