NTSB investigations, AR
4 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1993 | 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\" = 'AR' 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\" = 194)
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" = 'AR' 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" = 194) 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 FTW93LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Little Rock, ARThe inadvertent landing gear retraction by the pilot. A factor was the pilot's negative habit interference.NTSB MKC85FA076Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Hot Springs, ARThe first officer was making the landing and the acft bounced during touchdown. The captain's right hand, which had beennear the floor to the right of his seat, bumped the landing gear selector to the up position as the captain reached for the yoke. The…NTSB MKC84LA082Accident · No injuriesLimited investigationFinal reportMooney MK20B · Pocahontas, ARThe acft landing gear retracted during landing. The plt reported that the manually activated gear handle popped out of the gear down position during the landing roll. The plt indicated that he thought the gear handle was positively in the down lock position.NTSB FTW83LA064Accident · No injuriesLimited investigationFinal reportBeech E33 · Little Rock, ARDuring the landing roll, all three of the landing gear retracted as the pilot was applying brakes to turn off at the first exit. FAA inspectors found the landing gear handle in the down position with the circuit breaker popped. The flaps were also found in…