NTSB investigations: Wright R-1820 series, 2004
4 cases on aircraft whose registry engine model is Wright R-1820 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
| 1970 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 3 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2011 | 3 |
| 2012 | 4 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2025 | 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 year(c.\"eventDate\") = 2004
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67020'))
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 year(c."eventDate") = 2004
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67020'))
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 MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB CHI04LA147Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Manitowoc, WIFailure of the number 4 piston articulating rod resulting in a complete loss of engine power during initial climb. The ditch was a contributing factor.NTSB MIA04LA092Accident · 1 fatalLimited investigationFinal reportNorth American T-28B · Wesley Chapel, FLThe pilot's failure to verify security of the left engine cowling and its subsequent separation in-flight and collision with the vertical stabilizer resulting in the loss of aircraft control.