NTSB investigations: Wright R-1820-86
6 cases on aircraft whose registry engine model is Wright R-1820-86. 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
| 1988 | 1 |
|---|---|
| 1989 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2014 | 1 |
| 2016 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67200'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67200'))
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 ERA16LA328Accident · No injuriesClass 3 · LimitedFinal reportNorth American T28 · Greenwood, MSA total loss of engine power for undetermined reasons.NTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.NTSB CEN10LA272Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Oklahoma City, OKThe failure of the master rod bearing, which resulted in a loss of engine power.NTSB SEA07CA102Accident · Minor injuriesData collectionFinal reportNorth American Aviation Div. T-28C · Red Lodge, MTThe lack of suitable terrain for a forced landing. Contributing factors were the loss of engine power during takeoff for undetermined reasons, and rough/uneven condition of the terrain.NTSB SEA89LA058Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Jerome, IDThe failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel.NTSB CHI88DEM01Accident · Minor injuriesFinal reportNorth American T-28A · Schoolcraft, MIWhile the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…