NTSB investigations, SC
5 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 2 |
| 1997 | 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\" = 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" = '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" = 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 MIA97LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Orangeburg, SCFailure of the pilot to recover from the bounced landing. Contributing to the accident was the pilots complacency.NTSB ATL89IA026Incident · No injuriesIncident investigationFinal reportBeech 58 · Georgetown, SCThe plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched…NTSB ATL88DMG04Accident · Minor injuriesFinal reportMarrek Smyth Sidewinder · Honea Path, SCNTSB ATL84LA249Accident · No injuriesLimited investigationFinal reportCessna 150J · Leesville, SCThe pilot stated that while attempting to takeoff from a 1600 ft strip he was, 'unhappy with the thakeoff roll'. An aborted takeoff was initiated and when brakes were applied hard the nose gear collapsed and the aircraft nosed over.NTSB ATL84LA036Accident · No injuriesLimited investigationFinal reportCessna 210 · Charelston, SCWhile on downwind for a second touch and go landing the plt lowered the landing gear but received a safe indication only on the nose gear. After 2 hours of additional flights and 5 attempts to lower the gear the plt was forced to land with the unsafe…