NTSB investigations: Howard DGA-15P
5 cases on aircraft the registry lists as Howard DGA-15P, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1992 | 1 |
| 2006 | 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.aircraft_model_code IN ('4690506')
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\" = 260))
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.aircraft_model_code IN ('4690506')
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" = 260))
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 MIA06CA099Accident · No injuriesData collectionFinal reportHoward DGA-15P · Merritt Island, FLThe failure of the pilot to comply with the before landing checklist for his failure to lock the tailwheel.NTSB CHI93LA007Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Wichita, KSInadequate preflight planning/preparation by the pilot, the pilot's over confidence in his personal ability, and airplane performance data not followed by the pilot.NTSB LAX84LA398Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Tracy, CADuring the landing roll, the acft ran off the side of the rwy. The plt stated that he landed with a slight tailwind.NTSB LAX82DA116Accident · No injuriesFinal reportHoward DGA-15P · Livermore, CADuring landing roll the aircraft swerved to the right. The pilot countered with left aileron, rudder, and brake but the right wing came up, the turn tightened, and the left main gear collapsed.NTSB LAX82DA096Accident · No injuriesFinal reportHoward DGA-15P · Mesa, AZWhile approaching the destination airport, the owner/pilot asked the instructor pilot to land the aircraft. The instructor reported that he maintained a slightly higher than normal airspeed on final approach to compensate for variable wind conditions. He…