NTSB investigations: Continental 0-200 series, 1982
9 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Hard landing”. 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 | 9 |
|---|---|
| 1983 | 4 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 8 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 11 |
| 1999 | 5 |
| 2002 | 2 |
| 2003 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 4 |
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 ('17020')
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\" = 200))
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 ('17020')
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" = 200))
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 DEN82FTE28Accident · No injuriesFinal reportQuickie Q2 · Colorado Spring, COThe pilot stated he made a long final to the runway at approximately 80 mph. After touchdown, witnesses observed the aircraft to bounce three times before striking a runway distance marking sign and coming to rest 100 feet off the runway.NTSB NYC82DA234Accident · No injuriesFinal reportCessna 150D · Hyannis, MAThe pilot stated that she was cleared for landing on runway 24. She stated that as she turned onto final, and the aircraft was high, an additional notch of flaps was added. The descent to the runway was at approximately 90 mph. The aircraft touched down in…NTSB DEN82DA200Accident · No injuriesFinal reportCessna 150M · Missoula, MTPilot landing after cross-country in windy conditions. He says nose must have hit too hard because nose gear collapsed..NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…NTSB SEA82DA124Accident · No injuriesFinal reportCessna 150M · Corvallis, ORAt 0830 PDT on 7/22/82, the aircraft was found near the approach end of runway 35 resting on its nose with the nose gear broken. Operator personnel reported that it had been stolen sometime after 2200 PDT on the night before. Also during that time, someone…NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…NTSB ATL82DA207Accident · No injuriesFinal reportCessna 150 · Ft Eustis, VAThe student pilot was practicing landings in preparation for his private pilot check. There was a 70 degree right crosswind at 4 KTS. The pilot stated that he had landed hard due to a bad flare and the plane bounced. He thought that the aircraft would settle…NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…NTSB SEA82DA060Accident · No injuriesFinal reportCessna 150G · Camas, WAAfter receiving 2.9 hrs of dual instruction in this make and model of aircraft, the student proceeded on a supervised solo flight. The first approach and landing were observed by the instructor to be normal. The second approach was made with 20 degrees of…