NTSB investigations, 1996
5 cases where the first occurrence was “Gear retraction on ground”.
Cases per year
| 1994 | 1 |
|---|---|
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 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 year(c.\"eventDate\") = 1996
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\" = 198)
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 year(c."eventDate") = 1996 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" = 198) 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 FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.NTSB FTW96FA198Accident · No injuriesField investigationFinal reportBeech 1900D · Denver, COfatigue failure of the right main landing gear hydraulic actuator rod at the spherical bearing due to a lack of lubrication.NTSB CHI96LA122Accident · No injuriesLimited investigationFinal reportCessna 210K · West Chicago, ILMaintenance personnel's failure to comply with an airworthiness directive on the landing gear which led to a retraction/extension assembly malfunction.NTSB FTW96LA129Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Brownwood, TXthe pilot's failure to follow manufacturer's procedures and premature gear retraction.NTSB CHI96LA082Accident · No injuriesLimited investigationFinal reportDassault DA-10 · Romulus, MIfailure of the right landing gear locking mechanism.