NTSB investigations: Gulfstream American AA-5B, CA
5 cases on aircraft the registry lists as Gulfstream American AA-5B. 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
| 1980 | 1 |
|---|---|
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 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 ('3970106'))
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 ('3970106'))
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 LAX95LA114Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Pacifica, CAFailure of the Grumman pilot to maintain visual contact and clearance from the citabria, while overtaking that aircraft. Factors relating to the accident were: the hazy sky condition and the Grumman pilot's diverted attention to other traffic.NTSB LAX94LA258Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Apple Valley, CAthe pilot's failure to maintain an adequate airspeed in the takeoff initial climb and the resultant inadvertent entry into a stall/mush condition. High density altitude and downdraft conditions were factors in the accident.NTSB LAX92LA296Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Soledad, CAThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB LAX90LA140Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Auburn, CAPilot failed to attain the proper touch down point and the remedial action was improper. Contributing to this accident was that the pilot allowed the aircraft to porpoise during the landing rollout.NTSB LAX80FUG46Accident · Minor injuriesClosedPitts S2A · Redlands, CA