NTSB investigations, 1985
15 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\") = 1985
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") = 1985 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 NYC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Frankfort, NYThe plt diverted to Frankfort-highland en route from his original destination of utica, NY, because of IFR weather at utica. The plt stated that as the nose wheel settled to the rwy during touchdown, it dug into snow on the rwy and the acft nosed over. It was…NTSB ATL86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCStudent pilot was returning from a solo cross country flight. In his report the student said he flew a long final with the VASI showing a proper descent angle. The acft was landed with a shallow flare touching down in a flat attitude. It bounced, bounced…NTSB CHI85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Delta, OHThe plt was performing a soft fld landing. When the nose wheel settled onto the airstrip it dug into the soft terrain, collapsed and the acft nosed over.NTSB ATL85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Peachtree City, GAPilot was renewing proficiency in light acft. On first touch and go landing, according to his statement during phone interview, he flared, acft ballooned, landed hard and porpoised. During ensuing roll out nose of acft settled and prop contacted runway. Acft…NTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…NTSB MIA85IA211Incident · No injuriesIncident investigationFinal reportCessna R182 · Jacksonville, FLThe plt stated that he made a normal touchdown & on his landing rollout the nose gear collapsed. The landing gear was cycled several times after this occurrence & no abnormality was observed. No determination could be made of the malfunction of the landing…NTSB CHI85LA270Accident · No injuriesLimited investigationFinal reportCessna 310D · Carbondale, ILThe acft was landing at dest arpt after a two hr xcountry flt. At gear ext no green light. Pilot recycled gear but still no light. Emergency ext used and three green indicated. On ld roll nose gear collapsed. Uplock arm tube was broken on the nose gear.NTSB FTW85LA218Accident · No injuriesLimited investigationFinal reportCessna 421 · Mckinney, TXAfter landing while taxiing on the rwy, the acft's nose wheel started bogging down in soft asphalt on the rwy. The soft asphalt was pushed along in front of the wheel until it caused enough resistance to overstress the nose gear causing it to collapse. The…NTSB ANC85LA067Accident · No injuriesLimited investigationFinal reportCessna 150D · Wasilla, AKThe primary cause of this accident was the airplane striking the soft spot on the runway. Underlying factors were the pilot in command's inability to distinguish the soft runway surface from surrounding runway surfaces, and the unusually warm temperatures for…NTSB MIA85IA152Incident · No injuriesIncident investigationFinal reportCessna 402C · West Palm Beach, FLThe nose gear collapsed on touchdown. An exam of the nose gear actuating rod, the only positive down lock, revealed that it had been improperly adjusted.NTSB MIA85LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Brunswick, GAThe plt stated that his takeoff roll was normal, but just before he rotated, the nose gear collapsed. No determination could be made as to the nature of the malfunction during a post crash exam & retraction test of the landing gear.NTSB MKC85LA061Accident · No injuriesLimited investigationFinal reportCessna 320 · Lee'S Summit, MOWhen plt lowered landing gear he did not get a safe indication. Gear appeared to be down and warning horn did not sound when throttles were retarded; however, nose gear collapsed during landing roll. Examination of system did not reveal reason for collapse…NTSB FTW85LA122Accident · No injuriesLimited investigationFinal reportCessna 310G · Austin, TXDuring takeoff, the plt heard a loud noise as the gear was retracted. He continued to the destination, but when he arrived, he was unable to get a safe nose gear indication. During the landing, the plt delayed lowering the nose & kept the weight on the main…NTSB LAX85LA135Accident · No injuriesLimited investigationFinal reportBeech 65 · Camarillo, CAAn inspection of rwy 8 disclosed the acft touched down on the two main gear simultaineously, followed immediately by thecollapse of the nose gear. The acft's nose & both propellers contacted the rwy, with no indication of a yaw. The nose gear actuator ass'y…NTSB ATL85LA094Accident · No injuriesLimited investigationFinal reportChampion 7FC · Louisville, KYThe student plt departed from a snow covered rwy & proceeded on a solo x-country. When he returned, the nosewheel broke thru the snow crusted surface & collapsed, then the acft nosed over. The plt said there were ruts on the rwy from other acft which caused…