NTSB investigations: Howard DGA-15P, CA

8 cases on aircraft the registry lists as Howard DGA-15P. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

NTSB investigations: Howard DGA-15P, CA per year, 1968–2026: 8 cases
1968	1
1970	1
1974	1
1978	1
1980	1
1982	1
1984	1
2018	1

Where

Open the map

Latest cases

Query with SQL

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 ('4690506')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('4690506'))
  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 ('4690506'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR18LA278Accident · No injuriesClass 3 · LimitedFinal reportHoward DGA 15P · Kernville, CAA total loss of engine power during initial climb due to fuel starvation.Sep 30, 2018 · N9471H · Destroyed 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.Jul 16, 1984 · N5553N · Destroyed 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.Mar 22, 1982 · N5553N · Substantial damage NTSB LAX80DUG30Accident · Minor injuriesClosedHoward DGA-15 · Murrieta, CAApr 19, 1980 · N22418 · Substantial damage NTSB OAK78FVD32Accident · No injuriesClosedHoward DGA15P · Healdsburg, CAApr 23, 1978 · N3347G · Substantial damage NTSB LAX74DUG53Accident · No injuriesClosedHoward DGA15P · Lk Elsinore, CAMay 4, 1974 · N65E · Substantial damage NTSB OAK70DVD11Accident · No injuriesClosedHoward DGA-15 · Tracy, CAMar 11, 1970 · N62J · Substantial damage NTSB LAX69D0104Accident · No injuriesClosedHoward DGA15P · Rosamond, CAJul 23, 1968 · N67191 · Substantial damage