NTSB investigations: British Aerospace BAE JETSTREAM 3101, 1988
3 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2012 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 1988
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 year(c."eventDate") = 1988
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 CHI89IA023Incident · No injuriesIncident investigationFinal reportBritish Aerospace JS-3101 · Milwaukee, WILoss of lubrication to the outer wheel bearing, and the subsequent disintegration of the bearing. Contributing to the incident was the failure by maintenance personnel to properly inspect and grease the bearing.NTSB FTW88MA083Accident · No injuriesMajor investigationFinal reportBritish Aerospace BAE-3101 · Decatur, TXAirplane's encounter with rought terrain during an attempted forced landing. The forced landing was necessitated after the captain used improper procedures to shutdown the left engine in flight following an unexplained torque fluctuation.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,…