Fatal NTSB investigations: British Aerospace BAE JETSTREAM 3101
5 cases on aircraft the registry lists as British Aerospace BAE JETSTREAM 3101. 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
| 1988 | 1 |
|---|---|
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2000 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1500216'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1500216'))
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 DCA00MA052Accident · 19 fatalClass 1 · MajorFinal reportBritish Aerospace J-3101 · Bear Creek Town, PAThe flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…NTSB DCA94MA022Accident · 18 fatalClass 1 · MajorFinal reportJetstream BA-3100 · Hibbing, MNThe captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…NTSB ATL92FA060Accident · 2 fatalField investigationFinal reportBritish Aerospace BAE-3101 · Alcoa, TNThe pilot's failure to use the airplane checklist which resulted in a gear up landing; and the pilot's failure to maintain flying speed which resulted in an uncontrolled collision with the ground.NTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…NTSB ATL88MA089Accident · 3 fatalMajor investigationFinal reportBritish Aerospace 3101 · Springfield, OHA company designated instr and two f/o trainees were conducting a FAR 135 trng flt. The third apch was terminated with ago-around initiated over the rwy threshold at about 50 ft. after climbing to about 150 ft, the acft was observed to oscillate in yaw,…