NTSB investigations: Continental 0-200 series, 1985
7 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\") = 1985
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") = 1985
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 NYC86LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Marlboro, NJThe acft encountered what the plt described as a strong gust of wind on landing. The plt stated he experienced a wind shift of aprx 45 degs. The acft touched down fast and during subsequent bouncing the nose gear collapsed. The winds, according to the plt,…NTSB CHI86LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Ashland, OHThe student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing…NTSB CHI85LA387Accident · No injuriesLimited investigationFinal reportCessna 150 · Hastings, MIThe pilot was competing in a spot landing contest. The aircraft was reportedly observed about 4 to 5 feet AGL and slow just before it contacted the grass runway. The nosegear failed, dug into the ground, resulting in a nose over.NTSB DEN85LQA05Accident · No injuriesFinal reportCessna 150M · Santa Fe, NMThe plt experienced a hard landing while on a solo x-country flt. The plt reported the flt had been delayed until mid-afternoon because of mechanical problems at by that time the winds had picked up. The student plt also reported having little dual experience…NTSB CHI85LA331Accident · No injuriesLimited investigationFinal reportCessna 150K · Romeo, MIThe acft nosed over after contacting a ditch during a landing roll. The student plt, on his second solo flt, was practicing touch & go landings when the accident occurred. He stated he rushed on final apch because other acft were lined up waiting to takeoff.…NTSB FTW85LA279Accident · No injuriesLimited investigationFinal reportCessna 150L · Killeen, TXThe student pilot failed to properly flare the aircraft and touched down hard on the nose gear. This caused the aircraft to start porpoising from which recovery was not made. Aircraft continued to bounce until the nose gear collapsed. It then slid to a stop,…NTSB LAX85LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Concord, CAThe student was practicing touch & go takeoffs and landings. On the fifth approach to a landing the student plt reported that the acft was a little high and he applied full flaps. The acft bounced on initial touch down. While attempting to recover from the…