NTSB investigations, NC
6 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1985 | 1 |
|---|---|
| 1990 | 1 |
| 1999 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 'NC' 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\" = 190)
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" = 'NC' 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" = 190) 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 NYC08LA009Accident · No injuriesLimited investigationFinal reportCessna 170A · Roxboro, NCThe pilot’s loss of control during landing.NTSB NYC07CA139Accident · No injuriesData collectionFinal reportCessna 170A · Smithfield, NCCollapse of the left main landing gear during landing, for undetermined reasons, which resulted in substantial damage during a runway excursion.NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.NTSB MIA99LA248Accident · No injuriesLimited investigationFinal reportDouglas DC3C-S4C4G · Charlotte, NCthe pilot-in-command did not use the check list which resulted in the right main landing gear collapsing.NTSB ATL90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indian Trail, NCThe failure of the pilot to have the landing gear inspected after experiencing unsafe gear indications.NTSB ATL85LA128Accident · No injuriesLimited investigationFinal reportVarieze Duncan/Varieze · Ocracoke, NCDuring landing, the tab which connects the landing gear cross tube failed allowing the right gear to collapse. The acft has an experimental certificate. The failure appeared to be due to design limitations.