NTSB investigations: Continental TSIO-360 series, VA
7 cases on aircraft whose registry engine model is Continental TSIO-360 series. 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
| 1983 | 2 |
|---|---|
| 1995 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2009 | 1 |
| 2011 | 1 |
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 c.\"eventStateOrRegion\" = 'VA' 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 ('17019', '17023'))
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" = 'VA' 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 ('17019', '17023'))
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 ERA12CA028Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Culpeper, VAThe pilot's inadequate knowledge of the airplane's emergency gear extension procedures, which resulted in his failure to successfully perform a manual extension of the landing gear.NTSB ERA09CA508Accident · No injuriesData collectionFinal reportMooney 231 · Charlottesville, VAThe pilot’s inadequate preflight planning and lack of familiarity with the airport diagram, which resulted in a runway excursion onto a grassy area.NTSB IAD03LA073Accident · No injuriesLimited investigationFinal reportMooney M20K · Chesterfield, VAThe loss of engine power due to the fatigue fracture of the #2 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC99FA071Accident · 1 fatalField investigationFinal reportMooney M20K · Counts, VAThe pilot's failure to maintain control of the airplane.NTSB NYC95LA085Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Tangier Island, VAThe pilot's failure to maintain obstacle clearance which resulted in an inflight collision with a tree. Contributing factors are a crosswind and the pilot's failure to maintain directional control and his inadequate compensation for wind conditionsNTSB ATL83LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28AT-201T · Basye, VAThe flt instructor (CFI) was giving the private plt a familiarization flt. During an apch to rwy 23 at Basye, VA, at dusk, the acft got low & the CFI instructed the plt to add power. However, when the throttle was advanced, the eng reportedly did not respond.…NTSB ATL83FA145Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Roanoke, VAThe acft was on a x-country from buffalo, NY to new port richey, FL. The plt made an en route stop at painsville, OH, then proceeded toward greensboro, NC. While en route, he elected to land at Roanoke, VA because his fuel would be low if he continued to…