NTSB investigations, SC
6 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1987 | 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\" = 'SC' 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" = 'SC' 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 ATL87LA133Accident · No injuriesLimited investigationFinal reportBeech E-55 · Spartanburg, SCThe plt reported that he lowered the ldg gear and observed a down-and-locked indication on the ldg gear position light on final appch. During rollout, he felt a severe vibration in the nose gear and pulled back on the yoke in an attempt to reduce it. He then…NTSB ATL84LA152Accident · No injuriesLimited investigationFinal reportBeech E55 · Charleston, SCAfter the landing the acft landing gear retracted during a period of maximum braking to avoid an arresting cable. During the examination of the landing gear door damage it was determined that the landing gear was retracted during the landing roll.NTSB ATL84LA142Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Hilton, SCThe acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing…NTSB ATL84LA037Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Beaufort, SCThe plt stated that he started having problems with various eletrically operated components during the latter part of the flt. During descent into Beaufort, he lost the ability to transmit and communicated to ATC by transponder. The plt said he put the gear…NTSB ATL83LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Greenville, SCThe aircraft landing gear collapsed during landing rollout. The pilot stated that he raised the gear instead of the flaps during the landing roll.NTSB ATL83LA010Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Camden, SCAccording to the pilot, he received landing information from the UNICOM operator for runway 7. He was advised to keep the pattern tight to accommodate heavy traffic at the airport. While expediting to get off the runway after landing, he reached to retract…