NTSB investigations
435 cases where the first occurrence was “Midair collision”.
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\" = 270) 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" = 270) 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 LAX85LA367Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, CAAs the acft approached its home arpt, on a westerly heading and looking into the sun, the plt began the descent. The acft's left wing severed the left horizontal stabilizer and elevator from an approaching acft. The plt continued his approach and landed…NTSB ANC85FA163Accident · 6 fatalField investigationFinal reportCessna 180H · Mt. Palmer, AKAircraft collided with Cessna 180 and crashed on mountain side about one-quarter mile apart. Piper was sightseeing and Cessna was spotting sheep. Scattered clouds were reported about 300 feet above the points of ground impact.NTSB MIA85FA233Accident · No injuriesField investigationFinal reportCessna C-150 · Kissimmee, FLThe acft collided with another acft at about 300 ft AGL during the aproach to a practice precision lndg. After the collision both acft landed saftely.NTSB FTW85MA317Accident · 3 fatalMajor investigationFinal reportBeech 200 · Quinlan, TXN100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…NTSB CHI85LA291Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 6B · Battle Creek, MIThe envelope of Balloon N1533S was penetrated and torn by the basket of Balloon i-frog. The envelope was damaged to the degree that altitude could not be sustained. The aeronqut of N1533S was seriously injured upon ground impact. I-frog was landed without…NTSB FTW85FA261Accident · 1 fatalField investigationFinal reportCessna 150 · Temple, TXA midair collision occurred between a Cessna 150 in the traffic pattern and a Cessna 152 on a long low final to the same runway. The Cessna 152'S radio was mistuned, and the Cessna 150 had no radio installed. Neither could have heard warnings broadcast by…NTSB NYC85FA145Accident · 1 fatalField investigationFinal reportSikorsky S76A · Belmar, NJDuring takeoff & landing practice for a pre-solo plt the CFI saw a helicopter, N176FJ, approaching the arpt. N4956B, at the time of 1st sighting, was on a left base for rwy 3. The rotorcraft apparently did not see N4956B or hear any radio calls at this…NTSB FTW85FA230Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Junction City, KSArmy UH-1V and N7053R, a Piper PA-28, collided in mid air at 700 feet AGL. Both acft were in lvl flt. UH-1V was operating on a medical evacuation flt with a crew of four, one patient and two attendants. The UH-1V executed a successful autorotation with…NTSB ANC85LA109Accident · No injuriesLimited investigationFinal reportCessna 207 · Emmonak, AKThe pilot-in-command stated he was passed by the airplane N9975M and did not see it again until he was at his right rear and slightly below. The propeller of N9975M struck the aileron and during the evasive maneuvering the left main gear of N9975M struck the…NTSB LAX85FA239Accident · No injuriesField investigationFinal reportEarnst Skybolt · Paso Robles, CAA Cessna 150 and a home built skybolt acft collided while on a downwind leg of a traffic pattern to land. The skybolt was a competitor in a local aerobatic competition east of the arpt. The C-150 was returning from a student plt training x-country flt. Both…NTSB CHI85FA185Accident · No injuriesField investigationFinal reportBeech B35 · Sussex, WIA student plt was on his 1st solo x-country flt in a Cessna 152, N6464L. After taking off at the brookfield arpt (elev 850 ft), he had climbed to 2000 ft MSL & was heading 350 deg when he saw a Beech B35 (bonanza), N5182C, converging from his right. The…NTSB CHI85FA176Accident · 1 fatalField investigationFinal reportCessna R182 · Prairie Dusac, WIThis midair collision occurred approx 2 mi NE of sauk-Prairie apt. The pilots of the Cessna were in a climbing right departure turn at approx 1600 ft MSL heading approx 120 deg when a collsion occurred with a Piper heading approx 270 deg and descending. One…NTSB LAX85FA202Accident · 2 fatalField investigationFinal reportCessna 172M · Camp Verde, AZBoth acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close…NTSB FTW85FA117Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300 · Healdton, OKThe acft collided at 4,500 ft MSL within aprx 15 degrees of head-on. VMC with 30 mi visibility existed with plt reported winds aloft as being light from the west. En route recorded data indicated that N39516 was on a true course of 180 deg and N1162N was on a…NTSB LAX85FA123Accident · 2 fatalField investigationFinal reportCessna 120 · Irwindale, CAA Cessna 120, N9058Y, & a Cessna 152, N65599, collided in midair in the practice area for el monte, CA. Arpt. The two aircraft had departed the controlled arpt within three minutes of each other. Both had one instructor & one student aboard. The Cessna 152…NTSB DEN85IA025Incident · Minor injuriesIncident investigationFinal reportAerospatiale SA315B (Lama) · Oak City, UTBoth acft were performing external load operations. N5785V was in level flt to the north. N9362 was in a 60-70 kt slight climb to the southeast. Neither plt, both in rt seats, saw the other acft before contact. Three main rotor blades of N5785V passed through…NTSB ATL85FA007Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Morgantown, NCN2553A was in traffic pattern conducting touch and go landings. N32828 was maneuvering below the traffic pattern and was seen climbing in direction of N2553A. N32828 was flying westerly into the sun. N2553A was seen in a shallow left turn from crosswind to…NTSB MKC84FA272Accident · 2 fatalField investigationFinal reportCessna 195A · Akron, IAN19JW, a Cessna 195A and N8783X, a Cessna 182 departed mapleton, IA, at aprx 0805 on a VFR flt to Akron, IA, to attend a fly-in breakfast. The two acft did not travel the same route of flight to Akron, N19JW crossed over the midpoint of the arpt on crosswind…NTSB SEA84FA215Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · The Dalles, ORN6499J departed The Dalles municipal arpt shortly after 0930 PDT on a flt to vancouver, WA. N4622T departed chenoweth airfield ( aprx 4 NM west of The Dalles) at about 0930 PDT on a flt to The Dalles municipal arpt. A witness who observed both acft before the…NTSB NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.NTSB MIA84FA241Accident · 4 fatalField investigationFinal reportCessna 152 · Valdosta, GAThe two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…NTSB DCA84AA034Accident · 17 fatalClass 1Final reportBeech C-99 · San Luis Obispo, CAAt about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo…NTSB MKC84FA240Accident · Minor injuriesField investigationFinal reportCessna A188B · Stonewall, ARWhile engaged in aerial application, two acft working the same field collided in-flight. Pre-flight planning and briefing for the dual operation was not conducted. There were no inter-plane communications.NTSB MKC84FA229Accident · 1 fatalField investigationFinal reportPiper PA 36-375 · Bertrand, NEN3930E and N3968E had departed as a flight of two for aerial application. There was no record of preflight briefing or coordination planning. At completion of operations on the object field, N3930E advised N3968E by radio that he was making a final cleanup…NTSB SEA84FA172Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus A · Ephrata, WAA 'gaggle' of about 7 gliders were maneuvering in a climb when N919R climbed into the group. The plt of N17KS said he saw N919R closing and increased his angle of bank to about 100 degrees to try and avoid a collision. The leadingedge of the left wing of…NTSB LAX84FA378Accident · 2 fatalField investigationFinal reportCessna 182Q · Richmond, CAThese two acft were flying between 1500 and 2000 ft AGL when they collided over Richmond, CA. N103PD was on police surveillance circling to the left. N95726 was on a x-country flying a heading of about 350 degrees. The collision tore the right wing tip off of…NTSB SEA84LA159Accident · No injuriesLimited investigationFinal reportApplebay Sailplanes Zuni II · Ephrata, WAThe two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail.NTSB CHI84FA250Accident · 2 fatalField investigationFinal reportGrumman G-164B · Warren, MNN9367K was on departure and climbout to aerial application operations. N6533K was about to enter the traffic pattern to land and reload. Marks on respective airframes indicate N9367K was above and approaching N6533K from the latter's forward left quarter;…NTSB MKC84LA178Accident · No injuriesLimited investigationFinal reportSnow AT400 · Portland, ARBoth acft were about to touch down. N501PR was above N501JS. The pilot of N501PR stated that just before touchdown the collision occurred and resulted in severing of the tail section of N501PR. The pilot of 501JS stated N501PR flared out to land directly in…NTSB CHI84FA225Accident · 1 fatalField investigationFinal reportSchleicher AS-K13 · Stanton, MNThe tow plane and the sailplane it had towed to pattern alt collided on final approach of the pattern. The tow plane was supposed to follow the sailplane to land after it had dropped the tow rope. There was a low sun glare facing the towplt on the heading of…NTSB ANC84FA080Accident · 2 fatalField investigationFinal reportCessna 180G · Tyonek, AKTaking off from an abandoned road near a fishing camp, the Cessna turned back and descended with power on over his departure point, heading into the sun which was low on the horizon. It collided left wing to left wing with the Maule which had climbed out at a…NTSB LAX84FA319Accident · 2 fatalField investigationFinal reportCessna 152 · Half Moon Bay, CAThe two acft collided after N1920Y declared his intention to takeoff and was airborne aprx Half way down the rwy. The other acft was in a steep descent at mid-field when he dove into N1920Y. Both acft then crashed uncontrolled into the ground from an alt of…NTSB LAX84LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Ballard, CAThe pilot of N73857, a Cessna 172 and the pilot of N521ST, a Cessna 305 arranged prior to the flight to fly a 'missing man' formation with two other aircraft. The plt of N73857 was instructed to fly to the left rear of the lead acft, N521ST. The pilot of…NTSB ANC84FA073Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Platinum, AKThe herring season was to open at 1600 hrs. According to witnesses, about 30 acft were circling in left turns over merging schools of herring while the plts & their respective boat crews were awaiting the opening signal. The acft were circling under a low…NTSB ANC84FA059Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKA student plt in a Cessna 152, N45928, was inbound to land on rwy 33 at merrill field at the same time that another student plt in Cessna 152, N6479L, was departing from rwt 15. The student in N6479L was cleared for a 'city high' departure. After taking off,…NTSB LAX84LA245Accident · No injuriesLimited investigationFinal reportBeech E18S · Buellton, CAThese acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the…NTSB MIA84LA127Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · St. Augustine, FLThe plts of a Bucker jungmann, N1947G, & a pitts S-2B, N5302M, were practicing for an airshow. They began a maneuver called a 'mirror fly-by' in which the Bucker was rolled upside down & the pitts was flown underneath it. Due to the air flow over the wings…NTSB NYC84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Fitchburg, MAThe plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and…NTSB ATL84FA119Accident · No injuriesField investigationFinal reportPiper PA-31T · Benson, NCA Piper PA-31T, N9162Y, and a Beech 200C, N390AC, were involved in a midair collision while both were cruising at 17,500 ft in unlimited visibility. The Piper was tracking inbound on the 210 deg radial of the richmond VOR. The Beech was tracking inbound on…NTSB FTW84LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKBefore takeoff, a student & a commercial plt agreed to rendezvous & fly formation while the student took pictures of the commercial plt's acft. The student was to fly a Cessna 152, N4861B, while the commercial plt flew a Cessna 150, N704V6. They planned for…NTSB SEA84FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Kent, WAAt about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local…NTSB NYC84FA038Accident · 4 fatalField investigationFinal reportCessna 172P · Silver Greek, NYThe two acft were involved in a midair collision near Silver creek, NY. The plt of N4089P was flying in the left seat & using an instrument hood with a safety plt in the right seat. The plt of the other acft was on a pleasure flt with his daughter. Both acft…NTSB LAX84LA077Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Riverside, CAThe plt of a Cessna TU206F, N7320Z, stated that he advised other traffic of his position & intentions on the UNICOM freq as he entered a straight-in apch to rwy 24. At about the same time, the plt of a pitts special S-1, N20JK, had returned from a local flt &…NTSB NYC84FA032Accident · 2 fatalField investigationFinal reportBeech K35 · Stockholm, NJAt 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34…NTSB FTW84FA001Accident · 1 fatalField investigationFinal reportCessna 152 · La Porte, TXCessna 152, N6281Q, & Piper PA-38, N9132A, were both on local, solo student flts. The plt of a 3rd acft, who was holding short for takeoff on rwy 12, observed the Cessna 152 & Piper PA-38 on final apch. Recognizing the potential for a mid-air collision, he…NTSB LAX83FA382Accident · No injuriesField investigationFinal reportStinson 108-3 · Temecula, CAA Stinson 108-3, N12HK, piloted by a private plt, & a Cessna 152, N46757, piloted by a student plt, collided while both acft were ruising at 5500 ft MSL. The private plt (of N12HK) reported he was on a magnetic heading 130 deg & was indicating 92 mph (about…NTSB LAX83FA373Accident · No injuriesField investigationFinal reportCessna 152 · Fullerton, CAN6539L, a Cessna 152, and N1172H a Piper PA-32R-300 collided with each other approx 2 mi west of the Fullerton municipal arpt, at an alt of approx 1200 ft AGL. Both plts rept clear skies, a bright night, and no restrictions to vis. Both plts stated they made…NTSB NYC83FA188Accident · 4 fatalField investigationFinal reportCessna U206G · Brooklyn, NYA Cessna U206G float plane, N5328X, & a bell 206A police helicopter, N4797R, collided in flt over Brooklyn, NY. The aircrew of the police helicopter were on a traffic observation flt & had just reported traffic conditions in the vicinity of a toll station…NTSB MIA83FU005Accident · Serious injuriesFinal reportPterodactyl Ascender · Jacksonville, FLThe plts of 2 high wing, pterodactle ascender, ultralight vehicles took off & were operating in a designated area for ultralights. One plt (plt-a) was making touch & go landings while the other plt (plt-b) was maneuvering in the vicinity. After plt-a made a…NTSB ATL83FA224Accident · Serious injuriesField investigationFinal reportCessna 172 · Mocksville, NCN5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold.