Final NTSB investigations: Wright 1820G-2-3&5
6 cases on aircraft whose registry engine model is Wright 1820G-2-3&5. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67025'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67025'))
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 LAX82DA216Accident · No injuriesFinal reportNorth American 0-47B · Porterville, CADuring arrival for landing, the pilot was leading a flight of five dissimilar aircraft. After pitching out in a 360 degree, overhead approach, the pilot flew a fairly tight pattern. On base, when he would normally have felt the gear lock in place, his…NTSB CHI80FA054Accident · 1 fatalClosedGrumman J2F-6 · Toledo, OHNTSB MIA78FA128Accident · 4 fatalClosedDouglas DC-3 · Missing AircraftNTSB OAK77FVD09Accident · Serious injuriesClosedSikorsky S-58 · Alameda, CANTSB MIA72AM035Accident · No injuriesClosedLockheed 18-56 · Jacksonville, FLNTSB FTW71FQG35Incident · No injuriesClosedGrumman J2F-6 · Amarillo, TX