NTSB investigations, NJ
6 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 3 |
| 1985 | 1 |
| 1991 | 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\" = 'NJ' 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\" = 191)
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" = 'NJ' 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" = 191) 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 NYC91LA248Accident · No injuriesLimited investigationFinal reportFairchild SW3 · Atlantic City, NJA failure of the down lock roller bearings of the right main landing gear, as the result of an improper modification.NTSB NYC85LA075Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Colts Neck, NJThe plt returned to the arpt after a glider tow flt to land. During a 3-point touchdown, the acft hit a rut & bounced in the air. The plt recovered & made another 3-point touchdown, then heard a 'loud crack' & saw the right main gear separate. He stated that…NTSB NYC84LA297Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Teterboro, NJAcft was cleared to taxi to the rwy. Taxiway was blocked by construction. Plt elected to taxi to runup area to make a 180 deg turn. Plt turned right and right main gear went off pavement onto the soft shoulder and collapsed.NTSB NYC84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Caldwell, NJThe instructor plt stated that while he was giving instruction, he made a normal landing. When the wheels touched down, the right main gear snapped off & hit the side of the fuselage. The acft then skidded along the rwy until it came to rest.NTSB NYC84FA089Accident · No injuriesField investigationFinal reportCessna 401A · Linden, NJThe main landing gear collapsed after landing. A CFI awaiting takeoff said that the approach and touchdown were normal with the gear down. As the acft rolled the left main gear collapsed and the acft gradually left the rwy and became miredin mud. Inspection…NTSB NYC83FA241Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Atlantic City, NJUpon landing on rwy 29 the plt became concerned with another acft landing on rwy 11. Although the landing was long the plt elected to remain on the ground due to uncertainty of the other acft's position. When he reached the end of the rwy he turned the acft…