NTSB investigations: Bell 206-L4, TX
6 cases on aircraft the registry lists as Bell 206-L4. 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
| 1998 | 1 |
|---|---|
| 2006 | 1 |
| 2008 | 2 |
| 2013 | 1 |
| 2022 | 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\" = 'TX' 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 ('1182110'))
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" = 'TX' 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 ('1182110'))
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 WPR23LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206-L4 · Ft Worth, TXThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident, was the flight instructor’s inadequate supervision.NTSB CEN13CA276Accident · No injuriesData collectionFinal reportBell 206-L4 · Fort Worth, TXThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB CEN09FA086Accident · 5 fatalField investigationFinal reportBell 206L-4 · Sabine Pass, TXThe pilot’s failure to maintain clearance from the water. Contributing to the accident was the inadvertent encounter with instrument meteorological conditions.NTSB CEN09FA012Accident · 2 fatalField investigationFinal reportBell 206 · Conroe, TXA loss of control for undetermined reasons.NTSB DFW06CA058Accident · No injuriesData collectionFinal reportBell 206L-4 · Fort Worth, TXThe flight instructors failure to maintain main rotor RPM and improper flare, which resulted in a hard landing.NTSB FTW98LA274Accident · No injuriesLimited investigationFinal reportBell 206L4 · Hurst, TXThe flight instructor's failure to maintain control of the helicopter while attempting to increase the engine RPM while hovering. Factors were the prevailing high winds and the instructor's diverted attention.