NTSB investigations: Continental 0-200 series, TX
10 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with object”. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2006 | 1 |
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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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\" = 220))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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" = 220))
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 DFW06CA109Accident · No injuriesData collectionFinal reportCessna 150M · Roanake, TXThe pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.NTSB FTW99LA202Accident · No injuriesLimited investigationFinal reportCessna A150M · Alvin, TXThe flight instructor's excessive rotation while performing a soft field takeoff, which resulted in a delayed lift-off and the ensuing failure to attain obstacle clearance.NTSB FTW98LA105Accident · No injuriesLimited investigationFinal reportCessna 140A · Justin, TXthe pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.NTSB FTW95LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Seguin, TXThe pilot's failure to attain a proper climb rate after takeoff. A factor was the dark night light condition.NTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorNTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.NTSB FTW88LA157Accident · No injuriesLimited investigationFinal reportCessna 150M · Killeen, TXAccording to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,…NTSB FTW83LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Donna, TXAccording to the student plt, he was practicing a simulated emergency landing & had aborted the approach when the acft banked to the left, went out of control & crashed. An investigation revealed that the acft hit a palm tree, aprx 60 ft tall, then came to…NTSB FTW82DA376Accident · No injuriesFinal reportCessna 150C · Inez, TXPilot aborted downwind landing after overshooting. During go-around he flew under a powerline and collided with trees and a fence.NTSB FTW82DA339Accident · Minor injuriesFinal reportNorth American AT-6A · Abilene, TXThe pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6.