NTSB investigations, OK
5 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1983 | 2 |
|---|---|
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 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\" = 'OK' 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\" = 160)
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" = 'OK' 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" = 160) 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 FTW99TA183Accident · Minor injuriesFinal reportMcDonnell Douglas 500-E · Oklahoma City, OKDuring a practice autorotation, the pilot flared the helicopter too low, which resulted in the tailboom contacting the ground. A factor was the dark night light conditions.NTSB FTW95LA172Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Elk City, OKThe pilot's failure to maintain proper altitude during a hovering turn. A factor was the low temperature.NTSB FTW95LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-24APF · Tulsa, OKThe pilot's failure to maintain vref during approach and his improper flare touchdown that resulted in an excessive pitch up attitude following touchdown.NTSB FTW83LA211Accident · No injuriesLimited investigationFinal reportHughes 269B · Forgan, OKThe helicopter hooked a skid and rolled over while trying to land on a trailer. The plt stated that after surveying someproperty he landed next to the trailer used for transporting the acft. He then lifted off and while hovering over the trailer a skid hooked…NTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…