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 20070423007109ICessna R182 · Mesa, AZ(-23) Pilot stated that he was practicing crosswind landings. On his third landing, he touched down left gear first, then right gear. He stated that the aircraft began to vibrate, and the aircraft started rotating forward on its nose. He slowed the aircraft…Incident 20070423006829IAviat A1B · Neosho, MO(-23) The pilot [privacy data omitted] landed the float plane in a large farm pond near Neosho, missourit. Although the aircraft performance data indicated that the pond provided a sufficient landing distance for this aircraft, the pilot failed to stop in the…Accident 20070423006239APiper PA28161 · Palo Alto, CA(-23) On April 23, at approximately 09:00, N8171V a Piper pa 28-161 aircraft departed Palo Alto municipal airport with a student pilot at the controls. Shortly after aircraft rotation, the aircraft's engine quit and the aircraft made a powered off landing in…Accident 20070423005139AAmtr SEAWIND3000 · Knox City, MO(-23) Eyewitnesses reported they saw the aircraft flying at a low altitude and noted the engine was cutting in and out. The ensuing investigation revealed the airplane attempted an emergency landing in a field. However, the airplane landed short of the field…Incident 20070422826719ICessna 172P · Kent, OH(-23) When landing, aircraft struck runway, nose wheel first. Aircraft porpoised down runway three times. On the third try pilot got aircraft under control. (Pilot had no previous training on bad landing recovery).Incident 20070422016089ICessna 414 · Laredo, TX(-23) Aircraft landed at Laredo International airoprt (lrd) with landing gear unsafe condition known. Nose gear was not down and locked. Aircraft skidded to a stop. No injuries occurred. Aircraft was recovered from the runway and prepared for ferry flight to…Accident 20070422015179APiper PA23250 · Willimantic, CT(-23) The aircraft N5651Y, a PA-23-250, serial number 27-2767 was on approach to land on runway 27 at windam airport (ijd). At about 5 feet above the runway the pilot initiated a missed approach and go around. The aircraft pitched up at high rate and banked…Incident 20070422013119ICessna 172N · Ehrenburg, AZ(-23) The pilot accidentally extended the landing gear shortly before landing the amphibian aircraft on the Colorado river. The aircraft started taking on water and the four on board were able to exit the aircraft without injuries. They were picked up by a…Accident 20070422009739AAimm AMT200S · Wheeling, WV(-23) Instructor pilot did not realize the student failed to lower the landing gear. Glider landed on runway surface causing minor damage.Incident 20070422009659ITmpson Naviong · Chandler, AZ(-23) On landing left main gear collapsed at very slow speed. Aircraft came to rest on left tip tank with minor damage to bottom of tank. Rest of aircraft not damaged.Accident 20070422009059ACessna 150F · Paw Paw, MI(-23) Unlicensed pilot was flying on an expired student certificate. The 1900FT north/south field that he was flying from has trees and powerlines on both ends. The winds were 200 @ 15KTS gust 25KTS. The crosswind component would have been 7KTS gust 13KTS.…Accident 20070422008649AAmtr RV4 · Selma, AL(-23) Pilot lost directional control while landing on runway 15 at Craig airport, Selma, Alabama. The main landing gear collapsed after departing the runway, causing substantial damage to the aircraft. No injuries were reported as a result of this incident.Accident 20070422006909ARobsin R44RAVENII · Knox, IN(-23) Helicopter was observed by a witness making an approach over bass lake to apparently land at the owner's residence on the lake. The helicopter appeared to hover for a couple seconds at about 50 ft over the lake, then crashed into the lake. A witness…Accident 20070422006719AAmtr FJ1 · Banks, OR(-23) At approximately 12:30 pm on 22 April, 2007, a JD-4 glider, registration N366W was launched behind a tow plane at an altitude of 2,700' MSL. The duration of the flight was approximately 45 minutes with little altitude gain due to rain and unfavorable…Accident 20070422005759ABeech 58 · Harris County, GA(-23) Witness stated he observed aircraft heading northwest descending very fast in a 40 to 60 degree nose down attitude with various parts separating from the aircraft.Accident 20070422005719ACessna U206C · ID(-23) The pilot [privacy data omitted] wanted to take some photographs of his aircraft at a remote airfield for a brochure for his FAR part 13 business. The pilot [privacy data omitted] chose salmon bar airstrip at the confluence of the salmon and snake…Accident 20070422005449AAmtr SR3500MOOSE · Cotter, AR(-23) On April 22, 2007 approximately 1410 local time aircraft N360MM, a murphy moose SR3500, registered as experimental, amateur built airplane arrived north of Cotter, AR on 14 CFR part 91 VFR flight from clearwater, FL. The aircraft was flown by a…Accident 20070421824199ASmithc WHEELER2000 · Stuart, FL(-23) On April 21, 2007, about 1918 eastern daylight time, a smith wheeler exp 2000, amateur built airplane, had a loss of engine power and was ditched in the st. lucie river at Stuart, Florida. Visual meteorological conditions prevailed at the time and no…Incident 20070421020209IPiper PA24260 · Portsmouth, NH(-23) While flying from 1B9 to sfm the pilot reported a loss of oil pressure as he entered psm air space. Radioing the psm ATC he reported he had a problem and would try to make the psm airport which was 3 to 4 miles away. Realizing he would not make the…Accident 20070421017459AUnivar 415C · Brighton, MI(-23) On April 21, 2007 at 10:30 the pilot [privacy data omitted] (sport-student pilot) departed manipulating the controls of N99811 (Ercoupe) on a day VFR flight from Brighton, Michigan airport (45G) for howell, Michigan airport (ozw); he accomplished three…Incident 20070421011429IMaule M5210C · Greenville, AL(-23) While landing at the Greenville, Alabama (prn) airport, the pilot's seat locking mechanism failed, allowing the seat to move aft, resulting in loss of control during the landing. The aircraft departed runway 32 to the right, collapsing the left main…Accident 20070421010379ACessna 182Q · Key West, FL(-23) Aircraft N422G departed VFR on runway 06 at Key West international airport (eyw), enroute to leesburg international airport (lee). Aircraft was in a northeast direction leveled at 3500 ft. and attempting to pick up his IFR clearance from miami center.…Accident 20070421009199AAmtr COMPAIR6 · Sturtevant, WI(-23) Pilot-in-command landed long after a high pass approach and flew off end of runway. Aircraft landing gear became mired in mud of pond and aircraft flipped over.Accident 20070421008879APiper PA23250 · Ft Lauderdale, FL(-23) The pilot [privacy data omitted] departed ft. Lauderdale, FL, enroute to the Bahamas with four friends for an intended fishing trip. The pilot [privacy data omitted] just recently received his private pilot certificate, was a low time pilot, and even…Accident 20070421008699ACessna 182A · Russellville, KY(-23) Aircraft was on its second flight of the day for the purpose of dropping skydivers. During the landing on the second flight the pilot experienced a thermal while landing the aircraft on the grass between the runway and the taxiway. He initiated a…Incident 20070421008429IAerosl Skyrangerii · Ann Arbor, MI(-23) On landing encountered a crosswind, acft bounced on lt. MLG tire & NLG tire. Felt like NLG tire went flat so taxied onto grass and investigated. The pilot [privacy data omitted] discovered NLG tire flat and wheel bent, and NLG had a broken weld where…Accident 20070421007009APiper PA28140 · Williamson, MI(-23) The accident occurred April 21, 2007 on a Private strip at Williamson, Michigan. While attempting to land pilot stated "that he was coming in fast" bounced aircraft several times (nose wheel strut failed), causing aircraft to flip over.Accident 20070421006659APzlwar PZL104W35A · Waukesha, WI(-23) In flight engine failure due to fuel depletion. Emergency landing in a cornfield. During landing rollout aircraft struck a small berm and nosed over causing substantial damage to the aircraft.Accident 20070421005589ARobsin R22BETA · Van Horn, TX(-23) On April 21, 2007 at 1000 hours MDT, a Robinson R22 helicopter, N971SH registered to 2 romeo whiskey LLC, po box 570217, las vegas, Nevada, collided its rotor blades with the rotor blades of N991RW after landing. Visual meteorological conditions…Accident 20070421004589ADiamon DA20A1 · Warrenton, MO(-23) The pilot [privacy data omitted] was enroute to California after picking this aircraft up in doylestown, pa (kdyl). He had made a fuel stop at the madison county airport, (kuyf), in london, oh where he purchased 21.5 gallons of fuel. The useable fuel…Accident 20070421004279ARobsin R22BETA · Spanish Fork, UT(-23) During hovering autorotation, student misjudged descent, instructor tried to arrest the descent and couldn't stabilize the aircraft, they hit the ground and bounced up then had a dynamic rollover and the main rotor blades hit the ground and the aircraft…Incident 20070420016619ICessna 172RG · Batavia, NY(-23) On Friday afternoon, April 20, 2007, aircraft renter, the pilot [privacy data omitted] experienced a prop strike after touchdown at the Genesee County Airport (gvq) in Batavia, NY. There was an approximate 9 knot left crosswind when the pilot [privacy…Accident 20070420015569AUnivar 1083 · Pompton Plains, NJ(-23) The aircraft departed runway 1, at N07 (lincoln park, NJ). Upon takeoff the pilot noticed the engine power decaying and the aircraft not climbing. The aircraft hit a tree and a telephone pole prior to impacting the ground at [privacy data omitted]. This…Incident 20070420015239IBell 206B · Williamsport, PA(-23) During takeoff from portable landing platform, in crosswind conditions, aircraft drifted right, and right hand landing skid dropped off platform while still in contact with platform. Aircraft rolled to the right and pitched nose up. Right hand…Incident 20070420010529IBeech A36 · Canton, GA(-23) Pilot said he was coming in for a landing with the landing gear down, and missed his landing point and decided he would circle around and make another landing attempt. He raised the landing gear and accelerated the plane, however the plane was unable to…Incident 20070420010009IAmtr SPITFIREMK14 · Lakeland, FL(-23) Pilot was taxiing into the warbird ramp area without ground marshallers. Pilot began a left turn to position the aircraft into a parking space, and the left wing tip hit a parked golf cart. No ground personnel were assisting in positioning and/or…Accident 20070420006609AUrocop EC130B4 · Makawao, HI(-23) Two EC-130 B4 helicopters picked up passengers at a private residence for a part 135 charter. The first helicopter, loaded more heavily than the mishap aircraft, departed uneventfully with gusty tail winds on a track close to that flown by the mishap…Accident 20070420006549AJohnso JW9L · Saginaw, MI(-23) The pilot stated that after takeoff from runway 27 he suspected a potential engine problem and was returning to the field for a landing on runway 05. During the final phase of the landing at 304 feet from the prepared runway surface the aircraft…Accident 20070420004529ACessna 150E · Whitharral, TX(-23) On April 20, 2007, aircraft departed levelland, Texas (lln) for a round trip cross-country to vega, Texas (E52). Second pilot flew first leg of the cross-country and arrived at E52. Aircraft departed E52 for return trip to lln with first pilot at…Accident 20070419011319ACessna 172B · Los Angeles, CA(-23) On 04/19/2007 N7546X was on approach to Whiteman Airport for landing. N7546X bounced on landing, a go around was started. The aircraft stalled above the runway, then struck the ground and cartwheeled off the left side of the runway. The pilot and…Incident 20070419011069IAmtr Searey · Avon Park, FL(-23) Pilot states he had landed on runway 4 and was taxiing on the runway at approximately 30 mph toward the FBO when a gust of wind raised the left wing. The right landing gear collapsed and the aircraft slid on its hull approximately 900 feet down the…Incident 20070419010609IPiper PA28R200 · Bunnell, FL(-23) Gear collapsed while the pilot was performing an unplanned landing due to loss of electrical power which prevented the indication of the gear being down and locked. Proper procedure was not fully followed, abrupt yawing of the aircraft was not done,…Incident 20070419010009IAmtr Searey · Lakeland, FL(-23) On Thursday, 19 April 2007, at approximately 1101EDT, a progressive aerodyne "sea rey" kit-amphibian, built and flown by the pilot [privacy data omitted] aborted takeoff from runway 27L at Lakeland-Linder regional airport, Lakeland, FL. The aircraft…Accident 20070419008689ACessna U206G · Welaka, FL(-23) On April 19, 2007, at approximately 7:38 am, a Cessna 206, N2874B, piloted by [privacy data omitted] struck a static line and the top end of a pole structure supporting main electrical transmission lines over the st. johns river. The nose gear collapsed…Accident 20070419008619AMncoup 90A · Lakeland, FL(-23) On Thursday, 19 April 2007 at approximately 1929 EDT, a monocoupe 90-A piloted by [privacy data omitted], experienced a hard landing alongside the runway while attempting to land on runway 27R at Lakeland-linder regional airport, Lakeland, FL. The…Accident 20070419008229AHughes 369D · Kahuku, HI(-23) Including the reporting inspector, four(4) hnl-asi, 2 opps, & 2 a/w, were assigned to this on site investigation, approximately 20 man hours were dedicated to on site on scene. The aircraft encountered a collision with the earth upon attempting…Accident 20070419006949AAmrgen AA5B · Danville, VA(-23) On 04/19/07 at approximately 0910 EDT, the aircraft crashed into a heavily wooded area approximately one mile out while on approach to runway 13 at Danville regional airport (dan), Danville, Virginia. The aircraft had taken off at approximately 0730 EDT…Incident 20070419006459IBeech E90 · Rapid City, SD(-23) The pilot [privacy data omitted] and instructor pilot [privacy data omitted] made a gear-up landing in N323HA, a Beech E90 aircraft, on rwy 14 at Rapid City Regional Airport (rap). The aircraft received minor damage and the pilot and instructor pilot…Incident 20070419006119ICessna 172RG · Arkadelphia, AR(-23) On April 19, 2007 at approximately 1845 CST, Cessna 172RG, N9795B experienced minor damage due to an unintentional gear up landing at Arkadelphia, Arkansas. The private pilot (student) and sole occupant, stated that he failed to complete the landing…Incident 20070419005689ICndair CL6002C10 · Tulsa, OK(-23) During pushback from the gate the tug impacted the lower right side of the fuselage. Damage to the towbar and aircraft indicate that the tug driver obtained an excessive angle with the towbar.