NTSB investigations, AR
5 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 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\" = 192)
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" = 192) 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 MKC88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Texarkana, ARFollowing the completion of the ILS approach and landing on runway 22 at the Texarkana, Arkansas airport the nose gear of the aircraft collapsed during the landing roll. The aircraft collided with the runway causing substantial damage to the aircraft. The…NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…NTSB MKC87LA006Accident · No injuriesLimited investigationFinal reportCessna 421C · Hot Springs, ARThe pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,…NTSB FTW83LA063Accident · No injuriesLimited investigationFinal reportCessna 421C · Little Rock, ARNose gear collapsed during landing. No reason for collapse found.NTSB FTW83LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Pine Bluff, ARThe student pilot had made several touch-and-go landings on the same runway. He stated his last approach and touchdown were normal. Reportedly, the nose gear collapsed during the landing roll. The aircraft went off the left side of the runway and flipped…