NTSB investigations: Gulfstream American AA-5B, MA
4 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
| 1981 | 1 |
|---|---|
| 1985 | 2 |
| 1993 | 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\" = 'MA' 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" = 'MA' 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 BFO94LA010Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Sterling, MASeparation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.NTSB NYC85LA249Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5B · Manchester, MAPlt stated that during cruise flight at an altitude of 1200 ft the engine RPM decreaseed from cruise setting to between 900-1100 RPM. The acft was overwater and 2 miles from the coastline. He was unable to maintain altitude and he started a descent toward…NTSB NYC85FNA01Accident · Serious injuriesFinal reportGulfstream AA-5B · Boxborough, MAThe pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries.NTSB NYC81FNA21Accident · Minor injuriesClosedGulf Amer AA-5B · Stow, MA