FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20120626011139ILarson William E Sonex · Dunlap, ILThe aircraft was in cruise flight when the engine lost power and the oil pressure jumped up and down erratically. The pilot initiated a turn, and half-way thru the turn the engine completely quit running. The aircraft was landed in a bean field.Accident 20120626010919ASchweizer TH55A/269A · Grinnell, IAOn June 26, 2012, [privacy data omitted] departed new sharon in N488MC, enroute to ggi with a passenger. Approximatley 1215 local, [privacy data omitted] made an approach to a grassy area on the north side of the ramp into the wind. [privacy data omitted]…Accident 20120625014389APiper PA-32-300 · Gustavus, AKOn June 25, 2012, at approximately 0940 local time, N8908N, a 1969 Piper model PA-32-300 cherokee six aircraft operated by air excursions, LLC (yaxa) of Gustavus, Alaska, experienced a complete loss of engine power in flight. The 14 CFR part 135 scheduled…Incident 20120625013889IBuckeye Industries 582 Dream Machine · Pulaski, WIOn June 25, 2012, at 10:00 cdst a Buckeye 582 dream machine, powered parachute, made unscheduled hard landing in a farmer's field near Pulaski, Wisconsin. The pilot received minor injuries and the aircraft has substanial damage. The aircraft was being…Accident 20120625011609AStinson 108-2While on approach to the backcountry High altitude airstrip, the airman stated he was High and fast and touched down too long and applied maximum braking, causing the aircraft to noseover, coming to rest upsidedown.Accident 20120625011409ASocata TB21 · Gold Hill, NCThe aircraft departed runway 09 of goldhill airpark at 0400 hours on June 25, 2012 on an IFR flight plan. The aircraft made a left turn after departure and subsequently impacted trees before crashing into the ground approximately 1 mile from the airport. The…Incident 20120625011099ICessna 650 · Minneapolis, MNRight hand engine failure during climbout at 500 feet AGL enroute from ane-cid. Diverted to msp on single engine. Third stage turbine blade tips broken off. Total engine time=8196.4, total engine cycles=5910. PIC reck date of hire air carrier- 06/13/11/----…Accident 20120624017129AUniversal Stinson 108 · Cape Elizabeth, MEPilot declared a mayday due to engine failure while conducting a CFR 91 flight along the coast of Cape Elizabeth, ME (portland head light) he indicated to pwm ATC he wasn't going to make to the airport and or land and was going to land in the ocean. Aircraft…Accident 20120624013879AShelbyville, INAt 2030 on June 24, 2012 an unregistered destiny 2000 powered parachute was substantially damaged and the non-certificated pilot was seriously injured when the aircraft struck a 40 foot tall tree following takeoff from a runway at the pilot's residence.…Incident 20120624013429ILearjet 45 · Wichita, KSOn June 24, 2012 at 1353Z a Learjet registration number N45MR declared an emergency landing at mid Continent airport in Wichita Kansas due to smoke in the cockpit.Accident 20120624012789ADg-Flugzeugbau DG-500MB · Richland, WA[privacy data omitted] Was completing his 90 day currency in the motor glider and on his final approach to runway 26 with the engine stowed at Richland, WA (rld) thought his altiude was a bit low and tried to move the spoiler lever to retract the spoilers,…Incident 20120624012139IRaytheon Hawker 800XP · San Jose, CAAircraft blew a tire on left main landing gear and caught fire during a high speed taxi back down the runway.Accident 20120624012119ACessna 182 · Watsonville, CAOn June 24, 2012 at 1303 pacific daylight time, a Cessna 182, N55DN sustained substantial damage during an emergency off-airport landing approximately one half mile north-east of the Watsonville airport, California. The commercial pilot and sole occupant…Incident 20120624012059ICessna 182Q · Roswell, NMAircraft departed albuquerque, new Mexico (aeg) enroute to san angelo, Texas (sjt). At 11,000 feet and 22 miles northeast of Roswell, new Mexico the pilot experienced engine problems and the engine quit operating. Pilot executed emergency landing in a field.Incident 20120624012029ICessna 340 · Little Rock, AROn June 24, 2012, N555TY, a Cessna 340 was being operated by [privacy data omitted]on a VFR flight from kmdh to kcxo when the aircraft lost power in the left engine. The pilot requested to be diverted to Little Rock (klit) and declined to declare an…Accident 20120624011509ABurleigh Ron Bearhawk · Heber, UTTo be amended after maintenance review of aircraft.Accident 20120624011489ASikorsky S-58B · Brewster, WAPilot had just picked helicopter up to a hover when he noticed the tach reading zero, the engine starting to run rough, and the manifold pressure gauge reading approximately 7" high. He set the aircraft back down. As the wheels touched down he heard a bang…Accident 20120624010659AMooney M10 · Federalsburg, MDPilot was attempting to land at 7MD1, when he hit the power lines at the end of the rwy. The aircraft impacted the ground 163 feet from the power lines and came to rest 263' from the power lines. The aircraft was destroyed.Incident 20120623022209IMelton David Legrand Firestar · Elkin, NCGso FSDO received an anonymous call on June 25, 2012 reporting that a kolb Firestar ii had crashed on take off Saturday June 23, 2012 about mid morning. The pilot was reported as [privacy data omitted] and the owner as [privacy data omitted]. The aircraft…Incident 20120623018399ICessna 172M · North Little Ro, AROn June 23, 2012, at 14:00 CDT, a Cessna CE-172, N12678, conducted a takeoff roll followed by a lift-off to approximately eight feet then aborted the climb by landing within the remaining runway, then rolling off the end of the runway and across another…Accident 20120623017059AAmerican Legend AL3 · Rexburg, IDThe student pilot origanally soloed this aircraft on June 21, on June 23 the CFI flew with her again to be sure she was up to another solo. She landed fine and the instructor let her go for her 2nd solo flight. She flew for about 30 minutes and returned to…Accident 20120623014519ADehavilland Tiger Moth DH 82A · Fontana, CAPilot made an emergency landing in field after loss of engine power.Incident 20120623014509ICessna 170B · Chandler, AZPilot/mechanic arrived at the airplane a couple of weeks prior and discovered brake fluid under the right wheel. He replaced the "o" ring on the brakes and bled the brakes. The following Sunday, the airplane was flown uneventfully. On June 23, he departed…Incident 20120623014479IBeech S35 · Chino, CAN143K engine running rough at cruise altitude after switching fuel tanks. Switched back fuel tanks and engine still running rough. N143K requested to go back to kcno. N143K landed safely without further incident. 09/13/2012 - #4-6 Engine spark plugs were…Incident 20120623013939ICessna 150F · Traverse City, MIAfter landing on rollout, aircraft exited runway near end, turned around, returned to runway in opposite direction and came to a stop.Accident 20120623013909APiper PA-28-235 · Richmond, INPilot departed and during departure did not realize the fuel selector had been switched to wing tip tank which contained little fuel. Depleted fuel supply of tip tank and engine stopped operating,flm note: changed block 32 to reflect eir information- jar…Incident 20120623013229ITaylorcraft BC12-D · Anchorage, AKOn June 23, 2012 a single engine Taylorcraft BC12D aircraft landed at Lake Hood airstrip, Anchorage, Alaska, runway 31, at 1700 ast. The pilot was the sole occupant. As the pilot completed his landing rollout, he taxied off the runway at too high a rate of…Accident 20120623013219ALuscombe 8A · Mexico, MOOn 06/23/2012, [privacy data omitted] and a passenger, [privacy data omitted], were flying in a 1946 Luscombe 8A. They were in the flare to land at Riley'S Roost, located at 8626 hwy nn, Mexico, MO. Traveling approximately 60 mph and decelerating for…Incident 20120623012909IPiper PA-28-151 · Provincetown, MAOn June 23, 2012, aircraft N41372 operated by the owner (pilot) departed caldwell airport, new jersey (cdw) and crashed one (1) mile short of runway 7 in Provincetown Municipal Airport, MA. (Pvc). The pilot stated to the pvc airport manager that, he was…Accident 20120623012819ACox Vernon Lewis PA 18Pilot lost directional control on takeoff and struck a rock, causing loss of control and crash.Accident 20120623012719ACessna 172 · Veneta, OR6/23/2012 - At approximately 1515 (PDT), CE-172, s/n: 28381, N5781A, departed Crow-Mag airstrip (33OR -private) in Veneta, OR. With the pilot (roch d'auzon) and three passengers (robyn l. weir, christopher r. kent, erin t.f. noble). Ground witnesses report…Incident 20120623012189IDehavilland Beaver DHC-2 MK.1 · Mill Valley, CAPilot was performing a take off from water, at san francisco seaplane sea base. The aircraft rotated normally straight ahead and upon reaching about 100' of altitude the airspeed dropped over 20 (+) knots. The aircraft descended rapidly and landed straight…Accident 20120623012049ACessna A150K · Mamou, LAAircraft experienced engine problems. Engine became idle and when landing aircraft rolled over in rice field sustaining damage to its vertical fin. There was no passengers on board and the pilot was reported as unhurt. Investigation of the aircraft revealed a…Incident 20120623012009IDunlap Charles RV 4 · Hazelhurst, MSWhile landing in gusty crosswind conditions, the aircraft experienced a hard landing which resulted in minor damage to the landing gear and prop.Accident 20120623011449ACessna 177 · West Milford, NJOn 06/23/2012 at 1415 local after touch down on runway 6 at Greenwood Lake Airport and attempt to go around the aircraft drifted to the northwest side of the runway and landed hard on the grass. After landing on the grass the aircraft hit some bushes and…Incident 20120623011349ICessna 182B · Locus Grove, GAOn 06-23-2012, Locus Grove/Mallards Landing (GA04): sky diver sustains serious injuries and dies due to blunt force trauma to the head and was transported to henry piedmont medical center.Accident 20120623010669AHoyle Clifford L Fighter Escort Wings · Avondale, COAt 0830 local in the [privacy data omitted] road in Avondale, Colorado in VMC N2051 experimental aircraft, fighter escort wing, experienced substantial damage when aircraft landed gear up. One soul on board. No injuries.Accident 20120622021339ABeech A36 · Rock Springs, WYOn 06/22/2012, at approximately 1330 hrs. MDT, N4972M, a Beechcraft model A36 bonanza aircraft sustained substantial damage when it impacted terrain near Rock Springs-Sweetwater County, (krks) airport, WY. The sole occupant on board was not injured. Weather…Accident 20120622014409ACessna TR182 · Madison, ALThis was a normal landing on runway 36 at mdq. On landing the aircraft bounced several times. On the last bounce the aircraft impacted hard damaging the nose gear and firewall and causing the nose tire to blow out.Accident 20120622014349APiper PA-46-310P · Metropolis, ILAfter landing at Metropolis , IL the aircraft's nose gear collapsed, the main gear collapsed and then the aircraft slid off the runway.Incident 20120622013899IWillis Raymond L VM 1 Sport · Anderson, INDuring final approach for runway 30 at 70 knots the main gear touched down. And pilot lowered nose gear, at which time airplane floated shortly after which the pilot attempted to land again, the nose gear hit hard and then collapased. Flm note: please see eir…Incident 20120622013839ISchempp-Hirth Discus B · Alexandria, INAirmen returned to the airport because the thermal activity was decreasing. During the arrival, he applied partial spoiler to adjust his approach for landing. When the aircraft was 300-400 AGL and approximately 1500 feet from the runway, he stated that he…Accident 20120622013419ARaytheon C90GT · Morgantown, WVAircraft enroute to Morgantown, WV (mgw) from farmington, pa (PA88). Controlled flight into terrain (tv tower) less than 10 miles east of airport. Tower height listed as 518' (3114' MSL) on cincinnati sectional. No flight plan on file. Radar contact…Accident 20120622013369AChampion 7GCB · Kenai, AKThe airman was conducting low level observation of wildlife during conditions of gusty wind. The airman allowed the airplane to stall, and was unable to recover prior to impacting the ground. This caused substantial damage to the airplane and minor injury to…Accident 20120622011929APiper J5AOn June 22, 2012, aircraft N40985 operated by [privacy data omitted] departed beverly municipal airport and reported, unable to maintain altitude due to engine surging. The pilot was forced to land in the atlantic ocean 32 miles southeast of gloucester, MA.…Incident 20120622011399IShankle Joel Warren Falco F 8L · Athens, GAN703L was cleared to land on runway 27 ahn airport at approximately 1305Z. Upon touchdown N703L started bouncing along runway until the nose wheel appeared to collapse. The aircraft nosed over and stopped on the runway at approximately the 2000 feet remaining…Accident 20120621013089ACessna R182 · Santa Teresa, NMOn June 21, 2012, at 1520 MDT a Cessna 182, N4702R, registered to marine military academy (airwing) inc. landing gear collapsed on landing at Santa Teresa airport (5T6), Santa Teresa, new Mexico while on a personal flight. Visual meterlogical conditions…Incident 20120621013059IBeech S35 · Tulare, CA[privacy data omitted] Was flying in preperation for an upcoming flight review which was due in June of 2012. [privacy data omitted] Departed the Tulare airport and flew around the area before returning for practice landings at Tulare. When [privacy data…Accident 20120621012069ACessna 140A · Walnut Ridge, AROn jun 21, 2012 at approximately 1200 local hours, N9497A, a Cessna 140A, serial number 15318, was landing at Walnut Ridge regional airport in Walnut Ridge, Arkansas (karg) when the commercially rated pilot detected a gust of wind lifting the tail upward just…Accident 20120621011739AEdson Robert W Pietenpol AIR Camper · Hollister, MODuring the landing rollout on runway 12 at plk, the amateur-built aircraft drifted to the right. The pilot stated he pushed left rudder and the aircraft made a 180-degree turn to the left with the right wheel going off the runway pavement, resulting in the…