NTSB investigations: Hispano Aviacion HA-200 SAETA
7 cases on aircraft the registry lists as Hispano Aviacion HA-200 SAETA. 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
| 1990 | 1 |
|---|---|
| 1991 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2002 | 2 |
| 2004 | 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 ('4380115'))
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 ('4380115'))
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 DEN04LA089Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200 · Pueblo, COThe pilot's failure to maintain adequate airspeed resulting in an accelerated stall at an altitude too low for recovery. A factor was the pilot's lack of experience in the aircraft make and model.NTSB LAX02LA264Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Bakersfield, CAthe pilot's improper fuel system management, which lead to fuel starvation, and a loss of engine power. A factor in the accident was the pilot's decision to continue on the second leg of the flight with the gear in the extended position, which increased the…NTSB MIA02LA093Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200-Saeta · Perry, GAThe pilots failure to maintain airspeed while performing a turn at a low altitude, which resulted in a inadvertent stall, an uncontrolled descent, and an impact with trees and terrain.NTSB NYC98LA104Accident · 2 fatalLimited investigationFinal reportHispano Aviacion HA200B Saeta · Xenia, OHThe pilot's failure to maintain altitude clearance with trees after an improper decision to perform low level aerobatics.NTSB FTW97LA007Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Elk City, OKThe loss of aircraft control due to a fuel imbalance as a result of a partial failure of the fuel jettison system. A factor was that fuel could not be transferred from the left wing tip fuel tank to the rear fuselage fuel tank.NTSB CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.NTSB ATL90FA120Accident · 1 fatalField investigationFinal reportHispano Aviacion HA-200 · Tuskegee, ALImproper in-flight planning/decision by the pilot, and his failure to maintain altitude and clearance above the terrain, while perfoming low altitude, inverted flight. Factors related to the accident were: the lack of visual perception to the pilot at dusk…