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.
Accident 20070711019339ACessna 172RG · Roche Harbor, WA(-23) Loss of electrical power enroute to Roche Harbor. Pilot determined gear was down and locked without the aircraft landing gear indicator lights. Gear "collapsed" upon landing and slid off the side of runway into ditch. No injuries.Accident 20070711017709AWSK M18A · Tunica, MS(-23) Lost power while maneuvering to spray. Throttle did not respond to input. Changed direction and landed in field. Field was muddy, a/c flipped over. Substantial damage to a/c, minor injuries to pilot.Accident 20070711015999ABell 47G2A · Mercedes, TX(-23) Pilot stated that while surveying the field that he was about to spray, he hit a guide wire because he didn't see it. Helicopter crashed and burned after impact. No NMAC. No damage to property or persons on the ground.Accident 20070711014959AAmtr F11C2PJ · Deming, NM(-23) On July 11, 2007 at 0825 MDT a paul johnson F11C-2PJ, an amateur built aircraft, flipped upside down after landing at a private air strip east of Deming, NM. The aircraft sustained substantial damage. The pilot, the only occupant of the aircraft,…Incident 20070711013499ICessna 172N · Benbrook, TX(-23) Student pilot departed ksep at approx. 10:00 am, enroute to kgky. At approx. 1 NM northwest of kgdj pilot noticed smoke in cockpit, and soon afterward noticed engine vibrating and loss of power with smoke coming out of engine cowling. Student pilot then…Incident 20070711012349IAMD FALCON50MYST · Hampton, GA(-23) N370KP, an Amd-50 (falcon 50), struck a deer immediately after landing at Clayton County - Tara Field (4A7) in Hampton, Georgia. The deer suffered fatal injuries when it was bisected laterally by the left main landing gear assembly. Damage to the left…Incident 20070711011919IPiper PA34200T · Seattle, WA(-23) Landing gear was not in the extended position on landing.Accident 20070710832519ACessna 310R · Sanford, FLPilot reported smoke in the cockpit and diverted to Sanford airport while enroute. Pilot advised that he was shutting off the radios. The pilot was not heard from again. The passenger aboard the flight was [privacy data omitted], a 10580 hour ATP and flight…Accident 20070710832079ACessna 182R · Barre Montpeli, VT(-23) Pilot stated he landed long and fast on runway 35. When he tried to put the a/c down, he started to porpoise and then he went around and landed. During the porpoise, the prop struck the runway and the nose tire blew.Incident 20070710824779IRyan Navion · Houston, TX(-23) On approach to eyq, N91454'S engine started to sputter. The PIC declared an emergency when it was evident that he could not make the planned runway at eyq. The PIC made an off airport landing on an adjacent golf course. The aircraft came to rest on a…Accident 20070710017569ABbavia 7GCB · King Salmon, AK(-23) On July 10, 2007, about 1700 Alaska daylight time, a tundra tire-equipped champion 7GCB-117 airplane, N9897Y, sustained damage when it descended uncontrolled after takeoff, and impacted the ground, about 35 miles southeast of King Salmon, Alaska. The…Accident 20070710017209ABoeing 737232 · Tunica, MS(-23) Prior to departure flight mechanic (assisting the flight attendant) fell out of aircraft doorway while closing door.Accident 20070710016709ABell 47G5 · Jesup, IA(-23) Pilot stated he stopped aerial application operations because of high winds. Then he was attempting to take off and while at a low airspeed entered a whirlwind. The helicopter lost effective translational, rolled to the right, and settled into the corn…Incident 20070710013469ILear 35A · Boise, ID(-23) The aircraft departed runway 28R in Boise when the pilot felt a thumping in the airframe. It got worse so the pilot aborted the takeoff.Accident 20070710011619AAyres S2RG10 · Colorado City, TX(-23) On July 10, 2007, at approximately 1630 CDT, the pilot of N2254S, an Ayres S2-R agricultural aircraft, experienced engine failure and subsequently made an emergency landing. The aircraft sustained substantial damage during the forced landing in the…Incident 20070709824119IBeech 76 · Maple Lake, MN(-23) During a multi engine instructor examination, a short field landing was being attempted. Witnesses reported the landing gear was partially extended as the aircraft crossed the runway threshold. The aircraft landed gear up.Accident 20070709019989ACessna 182K · Edgerton, WI(-23) Pilot stated he lost electrical power and 10 minutes later his engine quit. While attempting an emergency landing at jana airport (58C), the aircraft veered off the runway and crashed into a corn field.Accident 20070709017559APiper PA32260 · Tyringham, MA(-23) Pilot elected too late to change course away from a severe thunderstorm.Accident 20070709017229APiper PA30 · Mulberry, FL(-23) 07/09/07 Aircraft departed lakeland, FL (lal) at 800, VFR southbound. No flight plan filed. No further contact with ATC after take off. It was reported by a polk county detective that the widow of the pilot speculated that they may have been enroute to…Accident 20070709016849ACessna A188B · Ulysses, KS(-23) On July 9, 2007, approximately 1000 central daylight time, a Cessna A188B single-engine agricultural airplane, N9076R, sustained substantial damage when it impacted terrain following a loss of engine power during initial takeoff climb near Ulysses,…Incident 20070709016489IPiper PA28161 · Chandler, AZ(-23) Student flying on first solo flight. Flew first landing and slowed rapidly on rwy 22R to make taxiway k turnoff. Engine quit as aircraft decelerated rapidly, but pilot had enough momentum to roll onto taxiway. Aircraft came to a halt on the hold line,…Accident 20070709015919ARobsin R22BETA · Albuquerque, NM(-23) On July 9, 2007 at 1009 MDT, a Robinson R-22-betan (N74536) registered to [privacy data omitted] and operated by the pilot [privacy data omitted] sustained substantial damage during an emergency landing in a parking lot following a partial power loss.…Incident 20070709015419IIsrael 1124 · Oklahoma City, OK(-23) Aircraft was landing at Wiley Post. On approach the crew did not get 3 green lights. After flying by the tower, the tower told them the gear appeared down. The aircraft landed fine, turned off the runway, and during the turn onto the taxiway the left…Accident 20070709014979ACessna 182G · Orland, CA(-23) Aircraft departed Orland/haigh field (O37) with 1 passenger on local demonstration flight. Glen co. sheriff reports after about 10 to 15 minutes, the engine began to run rough. The aircraft tried to return to O37 but lost altitude and landed in a corn…Accident 20070709014499AHiller UH12E · Mcgrath, AK(-23) The rotorcraft was hovering with one skid on the surface of a knife edge shaped ridge. A gust of wind hit the rotorcraft causing the tailrotor to strike a snow bank causing substantial damage to the tailboom and tailrotor.Accident 20070709014209APiper PA12 · Mukilteo, WA(-23) Approximately 06:45 PST aircraft N3964M went down in trees about 3000FT nw of pae paine field everett Washington. Pilot left stuart island Washington, (7WA5) about 40 minutes before. Before leaving pilot said that he keeps a fuel log, checked this log…Incident 20070709012419IRobsin R22BETA · Glendale, AZ(-23) Training flight. Approximately 8 miles north of Glendale airport (geu) heading southbound for landing at geu. Clutch caution light flickered on and off. Instructor pilot [privacy data omitted] pulled clutch circuit breaker per emergency procedure. At 2…Accident 20070709011309ADiamon DA40 · Heber City, UT(-23) Flying back from vernal with brother and 2 children onboard at 500 feet above mountains when they decided to go up a canyon to see if they could find any elk. As they flew up the canyon which was getting narrow, they could not gain altitude or airspeed…Incident 20070709011029ISwrngn SA226T · Tulsa, OK(-23) Pilot began to feel sick while taxiing out for departure. He stopped on the taxiway and rescue was called. Follow-up with the pilot indicates he head eaten a breakfast high in sugars and that his blood-sugar levels had fallen too low after his body…Incident 20070708825589ICessna 560CESSNA · Minneapolis, MN(-23) Normal approach and landing. Deployed spoilers once main wheels are on the ground. Nose gear collapsed on landing. Aircraft came to a stop remaining on runway centerline. Nose free fell out of the wheel well once the aircraft was raised and locked when…Incident 20070708021999ISnias AS350B · Gulf Of Mexico, US(-23) After a normal approach and landing, collective was lowered to flat pitch when a severe vertical vibration occurred. Emergency shut down procedures were employed. After exiting the helicopter found star flex had separated at blue blade and tailboom had…Accident 20070708020459ACessna 152 · Tracy, CA(-23) Student pilot departed the hayward airport (hwd) enroute to fresno airport (fat) under VFR flight conditions solo cross-country flight FAR 61.93. Pilot stated the engine started losing engine power and he decided to land at New Jerusalem Airport, Tracy,…Accident 20070708019949ACessna 177 · Danbury, WI(-23) A pilot, taking off out of voyager village's private airport, aborted his take off thinking that his aircraft wasn't climbing at a normal rate. In an attempt to land the airplane on the remaining runway, the airplane hit the ground with enough impact to…Accident 20070708018169AAmtr CH701 · Huntington, PA(-23) The experimental/homebuilt aircraft departed PN64 on runway 18 after a normal preflight and run-up. Upon reaching pattern altitude the pilot leveled off and proceeded to reduce power to the cruise setting. At that time the pilot noted that the power…Accident 20070708017729ACessna 182 · Lexington, TX(-23) Pilot reported he aborted takeoff at 65 knots due to seeing what he thought was oil on the windshield. He was approximately 300 feet from the end of the grass runway when he brought the engine to idle and applied the brakes. He traveled approximately…Accident 20070708017629ASkrsky CH54A · Los Olivos, CA(-23)The location of the accident was figueroa mountain rd, 5 miles north of state route 154 near the community of Los Olivos. This accident investigation involves a CH-54A, registration number N44094, serial number 67-18421 operated by heavy lift…Accident 20070708017599ACessna 182Q · New Haven, CT(-23) Pilot reported he encountered windshear 5-10 feet above runway and landed hard on nose gear.Accident 20070708017179ACessna 182K · Matinicus Isla, ME(-23) At approximately 1630 local on Sunday July 8, 2007, the pilot of N2762Q, CE-182-K, was returning to Matinicus Island (35ME) from knox county regional airport (rdk). After turning short final for runway 18 at Matinicus, the pilot stated an eagle appeared…Incident 20070708016459IAirtrc AT502A · Le Roy, IL(-23) [privacy data omitted] pilot was on approach to land at a rla approximately 4.6 NM NE of Le Roy, Illinois when he struck a power line. The aircraft sustained minor damage to the propeller, propeller spinner, and the airframe. No injuries were reported.Incident 20070708015329ICessna T210L · Llano, TX(-23) On July 08, 2007, central daylight time, a single engine Cessna 210 aircraft, N2391S was damaged due to forced landing. Pilot was forced to land resulting from fuel starvation/lack of fuel. The [privacy data omitted]pilot said he forgot to lower the…Accident 20070708014809AAirtrc AT400 · Delhi, LA(-23) Witnesses have stated that aircraft flew low over residential area (above powerlines) and made several passes over and alongside of houses/trailers. One witness stated that he saw the aircraft roll on side and then right itself, before losing sight of…Accident 20070708014039ABeech B90 · Louisburg, NC(-23) A jumper exited the aircraft while the aircraft was in a descent. The jumper struck the horizontal stabilizer resulting in serious injury to the jumper. Minor damage to the aircraft. The aircraft landed without incident.Accident 20070708013799AMooney M20F · Brooks, KY(-23) On July 8, 2007, at 1606 eastern daylight time, a Mooney M20F, N9180V, impacted terrain in a corn field approximately 4000 feet from the departure end of Brooks airport (73KY), Brooks, Kentucky. Impact forces with no post crash fire destroyed the…Accident 20070708012889ABbavia 7AC · Clarksburg, CA(-23) On July 8, 2007, the pilot [privacy data omitted] was severely injured while hand propping the engine on his aircraft prior to intended flight. After the engine started, he was struck by the propeller and suffered a loss of limb (left arm).Incident 20070708010549IBarfne Velocitysuv · Olney, TX(-23) N292F was approaching the Olney, TX (kony) airport and experienced a severe engine vibration followed by an engine failure. The pilot-in-command (PIC), [privacy data omitted] attempted two restarts with no success. He declared his emergency on the…Incident 20070707832379ICessna A185F · Northport, MI(-23) Pilot stated the following: he had landed in the water, in Northport bay, near Northport, MI and was attempting a takeoff when he noticed that aircraft was not getting up on the step and water was going over the pontoons. Pilot aborted takeoff and was…Incident 20070707825979IMooney M20D · Mackinac Islan, MI(-23) Aircraft landed with landing gear not fully in down and locked position.Incident 20070707023549IMooney M20R · Jasper, GA(-23) Flight originated at kcsg on 10/07/2007 at 2224L, direct kjsp on a 14CFR, part 91 IFR personal flight. On arrival to kjsp, pilot stated he entered the pattern for runway 16 and descended for landing. Pilot thought he was high when he flared. Passenger…Accident 20070707020849AGrob G102ASTIR · Truckee, CA(-23) After returning from a local flight in the vicinity of Truckee, CA the pilot entered the pattern at 1000 ft. AGL. On final, a side slip was used to compensate for the crosswind conditions. The pilot stated that the aircraft was flared normally…Accident 20070707020829ACessna 305A · Berkeley Towns, NJ(-23) A CE-305A, N12633, experienced sudden engine failure without any warning at 500' AGL northbound along the coast on a banner tow flight. The banner was immediately jettisoned. The pilot then applied carburetor heat, advanced the throttle and mixture and…