NTSB investigations: Wright R-1820 series
5 cases on aircraft whose registry engine model is Wright R-1820 series, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
|---|---|
| 1984 | 1 |
| 1991 | 1 |
| 2002 | 1 |
| 2004 | 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 ('67020')
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\" = 250))
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 ('67020')
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" = 250))
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 LAX04LA259Accident · No injuriesLimited investigationFinal reportNorth American T28B · Apple Valley, CAThe pilot's failure to maintain an adequate airspeed during the conclusion of a low pass, which led to a stall/mush.NTSB FTW02FA112Accident · 1 fatalField investigationFinal reportNorth American T-28B · Uvalde, TXThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB LAX91LA140Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58J · Chowchilla, CA1) The pilot not following the performance data for the aircraft, and 2) the pilot's inflight decision to turn the aircraft, which was at or near maximum gross weight, in such a direction that required more power than was available for the given flight…NTSB LAX84FA220Accident · 2 fatalField investigationFinal reportNorth American T-28B · Rialto, CAPlt was authorized by acft owner to test fly the acft around the traffic pattern with a local FBO owner on board. Plt made 3 flts, last of which culminated in the accident. On the first and third flts, unauthorized passengers were on board. FBO owner stated…NTSB DEN83FA058Accident · 1 fatalField investigationFinal reportNorth American T-28A · N. Winter Park, COAccording to the surviving passenger (the plt's 15 yr old son), they saw some skiers after crossing over a mountain pass. He stated that as they turned, his father said, 'let's buzz them.' He reported that they turned sharply, 'sort of dove down to buzz…