NTSB investigations: Eagle EAGLE DW-1, CA
4 cases on aircraft the registry lists as Eagle EAGLE DW-1. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1991 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3230203'))
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" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3230203'))
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 WPR11LA179Accident · Serious injuriesLimited investigationFinal reportEagle DW1 · Newman, CAThe pilot’s inadequate visual lookout and failure to maintain clearance from a vehicle during a low-altitude operation.NTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.NTSB LAX88DVA01Accident · Minor injuriesFinal reportEagle DW-1 · Modesto, CAWhile enroute for the purpose of spraying a field, the engine seemed to overspeed then lose power. The aircraft was landed on a soft field where during the landing roll, the aircraft nosed over. The propeller dome was found to have separated from the aircraft…NTSB LAX87DVA03Accident · No injuriesFinal reportEagle DW-1 · Modesto, CADuring an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…