NTSB investigations, 1983
16 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 22 |
|---|---|
| 1983 | 16 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 9 |
| 1987 | 14 |
| 1988 | 10 |
| 1989 | 9 |
| 1990 | 10 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 16 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 6 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 6 |
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\") = 1983
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 year(c."eventDate") = 1983 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 NYC84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Mifflin, PADuring the cockpit preflight the plt noticed an unsafe nose gear indication. The plt checked the nose gear & could see nothing unusual, & concluded that there was a faulty indicating system. During rotation the nose gear collapsed & this acft slid down the…NTSB MIA84LA046Accident · No injuriesLimited investigationFinal reportBeech 35 · Lake City, FLThe plt landed with the nose gear partially extended. The plt reported that he heard a crack while the landing gear was retracting after takeoff. He put the gear handle back down and continued to Lake City. After flying several low passes, the control tower…NTSB MIA84IA037Incident · No injuriesIncident investigationFinal reportCessna 182-RG · Jacksonville, FLOn landing touchdown the nosegear collapsed and the acft slid to a stop. One of the nose gear lock pins was found failed.NTSB SEA84LA024Accident · No injuriesLimited investigationFinal reportCessna A150K Aerobat · Nr. Wrangell, AKThe acft nosed over during landing on a snow covered sand bar. The weather was VMC. The plt said he underestimated the depth of the snow and upon landing the nose gear collapsed and the acft nosed over.NTSB FTW84LA053Accident · No injuriesLimited investigationFinal reportCessna 310Q · Amarillo, TXThe plt was starting a flt to reposition the acft from the tradewind arpt to the Amarillo intl arpt. He reported that he had started to takeoff on rwy 17, then aborted to avoid a Cessna 182. He reported the Cessna 182 plt was crossing rwy 17, on his way to…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…NTSB ATL84LA034Accident · No injuriesLimited investigationFinal reportCessna 150A · Dauphin Island, ALThe acfts nose gear collapsed during landing. The student plt was on a solo training mission to practice landings. The plt said he made a normal landing and as the nose gear was lowered he added slight right rudder to hold a roll parallel to the rwy…NTSB NYC83LA259Accident · No injuriesLimited investigationFinal reportCessna 182N · Binghamton, NYWhile landing in calm wind conditions, the nose gear reportedly collapsed on touchdown.NTSB MIA83FA224Accident · No injuriesField investigationFinal reportCessna 402C · Tampa, FLBefore landing, the plt moved the gear handle to the extend position & all 3 green gear down lights illuminated. However, when the nose was lowered after touchdown, the nose gear collapsed. An investigation revealed that the rod end, pn MS2124254K, on the…NTSB NYC83LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Colts Neck, NJReportedly, the plt-in-command (PIC) was on an annual flt check with an instructor plt (CFI) on board. The flying club had a requirement for an annual, club proficiency, check flt. During the flt, the check plt asked the PIC to land at the Colts Neck arpt. He…NTSB ATL83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Westminster, MDThe plt stated that he intended to fly to a 1600 ft private strip with trees on both ends. During the approach, he had planned to make a full stop landing. However, after touchdown, he decided to make it a touch-and-go landing. After lift-off, he felt the…NTSB ATL83LA166Accident · No injuriesLimited investigationFinal reportBeech C-23 · Birmingham, ALThe acft nose gear collapsed during landing on a student solo flt. The student and CFI flew a dual flt first and some airwork and 3 landings were accomplished. The 1st landing after the CFI got out of the acft was nose first with a bounceand a go-around. This…NTSB NYC83LA079Accident · No injuriesLimited investigationFinal reportCessna T210L · New Haven, CTAccording to an FAA interview, while on approach the plt did not identify the runway lights properly and landed to the left of the edge lights to runway 34. The acft landed off the runway in soft turf and the nose gear collapsed.NTSB MKC83IA063Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-36 · Salina, KSThe acft was on a flt from pitsburg, pa to Salina, KS with an en route stop at st louis, MO. During a briefing at pitsburg, the plt was advised of a NOTAM that the north 6800 ft of rwy 17/35 was closed, rwy lights obscured, 10 ft snowbanks. He did not get a…NTSB SEA83LA048Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesa, WADuring a short/soft field landing, the nose gear collapsed and the aircraft nosed over. The instructor was demonstratingthe landing at a private airstrip. He reported that upon touchdown, the aircraft rolled about 50 feet, then the nose gear dug in and the…NTSB NYC83IA056Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar 600 Aerostar · Philadelphia, PAThe aircraft veered off the runway during landing. The weather was VMC at the time. When the landing gear was lowered for landing no discrepancies were noted by the pilot prior to touchdown. During touchdown the aircraft veered to the left. The pilot took…