NTSB investigations: British Aerospace BAE JETSTREAM 3201
8 cases on aircraft the registry lists as British Aerospace BAE JETSTREAM 3201. 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
| 1991 | 1 |
|---|---|
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 2000 | 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 ('1500217'))
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 ('1500217'))
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 DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…NTSB FTW00RA196Accident · 19 fatalForeign investigationBritish Aerospace Jetstream 3201 · Chulum Juarez, MexicoNTSB NYC00IA159Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Lexington, KYA misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.NTSB LAX96FA228Accident · No injuriesField investigationFinal reportBritish Aerospace BA-3100/3201 · San Luis Obispo, CAThe flight crew's loss of directional control resulting from an attempted takeoff with the left propeller on the start lock. Factors in the accident were: the lack of cockpit caution/warning system/lights available to verify that the propellers are out of the…NTSB DCA95MA006Accident · 15 fatalMajor investigationFinal reportBritish Aerospace Jetstream 3201 · Morrisville, NC1) the captain's improper assumption that an engine had failed, and 2) the captain's subsequent failure to follow approved procedures for engine failure, single-engine approach and go-around, and stall recovery. Contributing to the cause of the accident was…NTSB MIA94LA166Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 3201 · Orlando, FLInadvertent deactivation of the parking brake by the pilot-in-command. Contributing to the accident was the worn condition of the parking brake assembly.NTSB BFO93IA057Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE3201 · Rochester, NYFailure of the main cabin door to be adequately secured for flight for an unknown REAS0N.NTSB CHI91MA260Accident · No injuriesMajor investigationFinal reportBritish Aerospace 3201 · St Louis, MOFailure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…