NTSB investigations
902 cases where the first occurrence was “Miscellaneous/other”.
Cases, newest first
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.\"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 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 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.NTSB DEN83LA043Accident · Minor injuriesLimited investigationFinal reportBell 206B · 11mi. So.Oftell, COPilot tried to land at 12,500 foot level. In the rotorwash whiteout he lost visual cues and rotor struck the slope because the right landing gear made snow contact.NTSB ATL83IA085Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Washington, DCThe acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach…NTSB FTW83LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Grandfield, OKShortly after takeoff, a child, who had been allowed to occupy the baggage compartment during the takeoff, fell from the acft when the door opened in flight. The child's grandfather, who occupied the rear seat, allowed the youngster to climb into the baggage…NTSB DEN83LA026Accident · No injuriesLimited investigationFinal reportBoeing 737-291 · Denver, CODuring a "power-back" operation from the terminal gate, a ground signal person and two wing walker were used in accordance with procedures. After reverse thrust was applied and the aircraft was rolling backwards. The signal person communicated an emergency…NTSB LAX83LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Palo Alto, CAThe pilot stated that during takeoff, when the aircraft was about 6 to 10 ft AGL, something hit the left propeller and the left side of the aircraft's nose. He did not see anything, but assumed the plane had struck a large bird. Darkness and the baggage door…NTSB SEA83IA027Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Boise, IDShortly after climbout from denver the first officer noticed the captain twitch and asked if he was okay. The captain answered affirmatively but donned his oxygen mask at the co-pilot's suggestion. About 20 minutes later the captain stiffened with his left…NTSB FTW83LA049Accident · No injuriesLimited investigationFinal reportCessna 150H · Addison, TXPilot hand propped engine with aircraft cockpit unattended. Aircraft started taxiing and collided with another unattended aircraft parked on the ramp.NTSB DEN83LA031Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Leadville, COThe aircraft was taking off in snow with wheel pants installed. The pants filled with snow and plane pulled to left. In attempt to recover directional control and get back on the runway the aircraft hit the asphalt ridge on the edge of the runway separating…NTSB DEN83LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Ignatius, MTAccording to the pilot, the passenger door opened before lift off. He attempted to brake the aircraft in wet snow and ice and slid off the end of the runway into a ditch. The investigation revealed the aircraft had a past history of the entry door latch…NTSB ANC83LA013Accident · No injuriesLimited investigationFinal reportBeech A36 · Fort Yukon, AKDuring a night approach to runway 03 at Fort Yukon, AK, the pilot neglected to activate the runway lights, as prescribed on the jeppeson approach chart, and mistook a row of white lights on buildings as the runway lights. Upon landing on a parking ramp the…NTSB SEA83LA020Accident · No injuriesLimited investigationFinal reportCessna T210G · Mccall, IDThe pilot reported that when he applied back pressure to raise the nose for takeoff, the aircraft felt sluggish, so he released some back pressure to gain airspeed. The pilot reported he then heard a loud metallic "bang" and stated that a vibration started in…NTSB FTW83LA033Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Austin, TXThe pilot penetrated the top of a cumulus cloud while climbing from 18000 to 20000 feet. A sharp jolt was felt and turbulence continued for 3-4 seconds. A stewardess fell and broke her ankle.NTSB FTW83IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Kenner, LAThe plt departed with a tail wind which exceeded the allowable component. Rotation was observed to have occurred at the departure threshold. The acft was estimated to be at 25 to 30 ft AGL when it was 1330 ft beyond the departure end of therunway. Two persons…NTSB DEN82DA202Accident · No injuriesFinal reportPiper PA-34 · Langdon, NDCabin door came open in flight and pilot made a precautionary landing. During roll-out nose gear collapsed as aircraft weight settled on it since it had not fully extended.NTSB CHI82DA343Accident · No injuriesFinal reportCessna 310A · Wheeling, ILThe pilot could not get the gear down green light to come on. Several checks made including a fly-by and a advisory that the gear appeared down. During the landing roll the right gear collapsed. Examination of the landing gear system revealed a bent righthand…NTSB FTW82DQA23Accident · Serious injuriesFinal reportRaven RX-6 · Albuquerque, NMThe pilot reported that the balloon was inflated and launched at about 0700 MDT. Later, the wind velocity increased and a final landing was made at about 0930 MDT. During the landing, a ground crewmember's leg was broken when it was hit by the gondola.NTSB SEA82DA120Accident · No injuriesFinal reportHughes 369D · 35 W. Of Ketchi, AKThe pilot was conducting a sling load operation with a 50 ft cable attached. After the last sling load was moved to a new drilling site, the pilot elected to leave the cable attached since there was no suitable landing area nearby. He stated that the cable…NTSB FTW82DA276Accident · No injuriesFinal reportCessna T188C · Marvell, ARAn aerial application of an oil-based material resulted in a smearing of the windscreen. The pilot landed on a grass strip to clear the windscreen, and during, the landing, the aircraft flipped over. The pilot said when he applied brakes, the left wheel broke…NTSB FTW82DA264Accident · No injuriesFinal reportGlassflugel 604 · Refugio, TXThe pilot accidently released the tow line at about 50 feet AGL when his parachute caught on the tow release handle. In attempting to turn to the runway, he dragged a wing. The glider fuselage broke aft of the cockpit.NTSB DEN82DA125Accident · Minor injuriesFinal reportErcoupe 415-C · Wamsutter, WYThe pilot became sick during the flight and elected to land on a highway. He took spacing behind a truck, but the truck slowed down, so he continued the landing beside the highway. After lowering the nosewheel, it hit a ditch and collapsed, and the aircraft…NTSB MKC82DA102Accident · No injuriesFinal reportBalloon Works Firefly 6 · Hudson, IAThe Balloon was in a descent and was approaching the landing area when the burner pilot-light went out. Without the burner, the pilot was forced to land short of his selected field. He spilled the air from the Balloon and touched down just short of an 8000…NTSB MKC82DA099Accident · Serious injuriesFinal reportCessna 500 · Topeka, KSWhen a passenger was boarding the aircraft, she inadvertently released the latch that held the door open. The door swung toward the closed position, struck the back of the passenger's foot, and severed the tendon. There were thunderstorms in the area and the…NTSB CHI82DA202Accident · Minor injuriesFinal reportCessna 150 · Cambridge, MNOn his first solo flight the student pilot stated he panicked at about 400 feet AGL and decided to land in a plowed field. During the landed sequence the aircraft nosed over.NTSB NYC82DA109Accident · No injuriesFinal reportRobinson R-22 · Danbury, CTDuring a practice autorotation, just prior to flare, a loud noise was heard and the pilot stated that the aircraft veered to the right. A partial flare was made and after making contact with the ground the helicoper bounced back into the air. The rotor blades…NTSB NYC82DA106Accident · No injuriesFinal reportSchleicher ASW-15 · Plymouth, CTThe pilot stated that he thought he heard the rudder pedals click into their detented/locked position when they were adjusted before takeoff. However, while being towed for takeoff, the rudder pedals slipped forward about 1 to 2 inches. The pilot reached down…NTSB SEA82DA076Accident · Serious injuriesFinal reportCessna 182F · Medford, ORAfter takeoff, engine oil began to accumulate on the windshield and restrict forward visibility. The pilot returned to land, bounced during landing, and elected to go-around. During climbout the aircraft struck trees on rising terrain and crashed. The owner…NTSB CHI82DA177Accident · Minor injuriesFinal reportBlanik L-13 · Warren, MNThe pilot was having difficulty controlling the glider during the tow and released prematurely. The destination was 12 to 14 miles away with 10-15 kt headwinds. When the pilot decided the destination could not be made a road was selected for a forced landing…NTSB FTW82DA183Accident · No injuriesFinal reportChampion 7EC · Southlake, TXDuring takeoff, the private pilot sitting in the front seat, thought the cowling was loose. The pilot informed the owner and commercial pilot in the rear seat who took control and decided to return to the airport. The pilot landed short of the runway and the…NTSB FTW82DA163Accident · No injuriesFinal reportCessna TU-206A · Rachal, TXThe aircraft wreckage was found by a rancher on may 1, 1982. The date of accident and circumstances could not be determined. The accident reporting forms sent to the registered owner were returned undelivered. Dea found 340 lb. Of marijuana on board the…NTSB SEA82DA057Accident · Serious injuriesFinal reportHiller-Soloy 12E · Christmas Valle, ORThe helicopter was being used to string a transmission line. A rope (attach line) was used to connect the helicopter to the transmission line. The rope became detached and the pilot landed to have it reattached. A man, involved in the ground operations,…NTSB DEN82IA049Incident · No injuriesIncident investigationFinal reportGulfstream G159-C · Denver, COOn final approach after a normal flight, the copilot became incapacitated while reading the final approach checklist. The captain continued the approach and made an uneventful landing. After the passengers had deplaned, the copilot suffered a seizure while he…NTSB MIA08CA076Accident · 1 fatalData collectionFinal reportBeech C24R · Mobile, ALUndetermined.NTSB MKC82IA042Incident · 1 fatalIncident investigationFinal reportBoeing 707-131B · Las Vegas, NVThis incident occurred when there was no intent to fly. On 3-8-82, a Boeing 707-131, owned and operated by twa, was receiving routine maintenance in Las Vegas, NV. During the check, the servicing valve on the forward water tank would not open. A twa mechanic…