NTSB investigations, LA
4 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1983 | 2 |
|---|---|
| 2001 | 1 |
| 2005 | 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\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 100)
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" = 'LA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 100) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 DFW05CA088Accident · Serious injuriesData collectionFinal reportBell B-206L-1 · Galliano, LAThe pilot's abrupt input of the collective while the main rotor RPM was at idle, which resulted in a separation of the tail boom.NTSB FTW02LA033Accident · No injuriesLimited investigationFinal reportBell 407 · Erath, LAThe pilot's inadvertant application of full right pedal which resulted in the baggage compartment door to open in-flight and a tie down rope to become entangled in the tail rotor drive system, and the failure of the tail rotor drive shaft resulting in the…NTSB FTW83FA259Accident · 2 fatalField investigationFinal reportCessna 180J · Harvey, LAA navigable waterway, Harvey canal, was being used as a seaplane base. In that area, a set of power lines were suspended over the canal by 2 tall towers. The lowest line over the canal was 160 ft above the canal surface, but the lines dropped to heights of…NTSB FTW83FA251Accident · 1 fatalField investigationFinal reportEnstrom 280C · Opelousas, LAThe helicopter was observed to lift off to a hover and began an erratic hover. The acft pitched up and spun throwing theplt out and fatally injuring him. Witnesses said they did not know the plt was going to fly the helicopter. The opinion was that it was to…