NTSB investigations, 1983
18 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 35 |
|---|---|
| 1983 | 18 |
| 1984 | 43 |
| 1985 | 44 |
| 1986 | 51 |
| 1987 | 43 |
| 1988 | 43 |
| 1989 | 45 |
| 1990 | 28 |
| 1991 | 45 |
| 1992 | 28 |
| 1993 | 22 |
| 1994 | 15 |
| 1995 | 28 |
| 1996 | 36 |
| 1997 | 44 |
| 1998 | 25 |
| 1999 | 32 |
| 2000 | 41 |
| 2001 | 40 |
| 2002 | 24 |
| 2003 | 37 |
| 2004 | 34 |
| 2005 | 33 |
| 2006 | 34 |
| 2007 | 34 |
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\" = 430)
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" = 430) 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 LAX84IA119Incident · No injuriesIncident investigationFinal reportBoeing 707-123B · Oakland, CAThe acft experienced a strong shimmy & vibration on takeoff which was attributed to deep ruts in the snow. After landingon deceleration the vibration became so severe that the plt stopped on the rwy centerline & ordered an evacuation. It was determined that…NTSB FTW84LA099Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Imperial, TXThe plt reported that when he was in cruise flt at 300 ft AGL, a sudden violent shudder went thru the whole helicopter, then the shudder stopped. He noted no change in the flit characteristics or eng power. The plt elected to make a precautionary landing by…NTSB SEA84LA025Accident · No injuriesLimited investigationFinal reportBell 206-BIII · Kooskia, IDThe helicopter landed hard and rolled over to the right. The events started when the pilot heard the end of a seat belt banging against the outside of the acft where it had been caught in the door. The pilot decided to land and secure the belt. During landing…NTSB DEN84IA023Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Denver, COApproaching from the east there are 4 parallel 'strips' at the arpt. From l to r they are rwy 26L, taxiway 'charlie' rwy 26R & rwy 25. Rwy 26L & taxiway charlie are the same length. All 4 are concrete covered. The flt was cleared to landon rwy 26R. Rwy 26L…NTSB MIA84IA025Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300B4-2C · Miami, FLDuring takeoff ground roll the NO-4 tire failed followed by failures of the other surrounding tires. The takeoff was aborted and there was no fire. The fuse plug in the NO-4 tire was found partially melted.NTSB NYC84LA015Accident · 1 fatalLimited investigationFinal reportShort Brothers SD3-30 · Middletown, PAAfter takeoff on a flt to Washington, DC, the aircraft was climbing thru about 3500 ft when a person (riding as a passenger) moved to the right rear door, opened it & departed the acft. Prior to the flt, an associate, who was an acft refueler, saw the person…NTSB ATL84IA024Incident · No injuriesIncident investigationFinal reportBritish 1-11/204/AF · Washington, DCOn initial climb but the foward right galley service door blew open for undetermined reasons. The acft returned and landed without further incident. The door warning light did not come on.NTSB LAX83FUJ16Accident · Serious injuriesFinal reportSemco Challenger · Tucson, AZThe pilot was outside the basket when the balloon took off. He grabbed the deflation handle and the balloon carried him aloft. He fell from about 40 ft AGL onto his head and was seriously injured. The pilot reportedly was going to tether the balloon. During…NTSB CHI83LA404Accident · Serious injuriesLimited investigationFinal reportMockrud Volksplane · Cottage Grove, WIThe owner of the new home built acft had given the plt permission to taxi the plane, but not to takeoff. The plt stated that he inadvertently became airborne while making a high speed taxi check, then the eng lost power. A witness stated that the acft became…NTSB LAX83LU017Accident · Serious injuriesFinal reportBird Bird · Mccloud, CAWhile landing on ranch land, the utralight vehicle touched down without incident. However, during the landing roll, the plt put both feet down to slow the landing roll, & subsequently, broke both legs. He stated that he had misjudged the airspeed when he put…NTSB SEA83LA182Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Arlington, WAThe acft nosed over while taxiing unoccupied after being hand propped for a start by the pilot. The pilot stated that hewas unable to start the acft normally so he hand propped it with no one in the cockpit. The unoccupied acft taxied from the ramp across the…NTSB FTW83LA350Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kemah, TXThe plt had landed in a restaurant parking lot. When he was informed that a local ordinance had been passed prohibiting helicopter operations from restaurant parking lots & that the police had been called, he prepared to takeoff. As the plt was preparing to…NTSB MIA83FA159Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · San Juan, PRAs the acft was departing, the airline company received info concerning a bomb threat. The aircrew were instructed to return to the arpt & land. After landing, the acft was parked at an isolated area & portable stairs were positioned at the left forward door.…NTSB SEA83IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, ORA broken hydraulic line near the left main landing gear allowed hydraulic fluid to leak on to the APU exhaust. The resultant smoke then was picked up by the left airpack and was blown into the cabin. The crew then ordered an evacuationof the passengers.NTSB LAX83LA250Accident · No injuriesLimited investigationFinal reportCessna 337B · Sedona, AZThe acft made a forced landing and collided with a pine tree after a takeoff with a tow bar attached to the nose gear. The pilot reported that he attached a tow bar to get the acft level to measure the oil quantity in the engine. After thepreflt inspection he…NTSB LAX83IA216Incident · No injuriesIncident investigationFinal reportCessna C-172-N · Huntington Beac, CAThe left aileron sustained damag under undetermined circumstancea. A near miss was described by the pilot and could not be substantiated by radar.NTSB LAX83FUG14Accident · Serious injuriesFinal reportSchweizer 2-33A · North Shore, CAThe rated airplane pilot was taking flight instruction for a glider rating. He had made aprx 11 previous solo flts. The accident sequence began while the sailplane was being launched with a wench tow. The plt reported that the wench cable failed when the…NTSB CHI83IA097Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC10-10 · Chicago, ILToo high a deck angle was attained during the flare & the acft floated dragging its tail on touchdown & leaving a 2 ft piece of metal on the rwy. The first officer was at the controls.