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 20061120029709IBeech A36 · Monroe, LA(-23) On 1-20-2006, pilot departed camden, ar and flew N4467S to Monroe, LA. Upon arrival pilot was cleared for a left downwind for runway 36 and cleared to land. Pilot reached and pulled down the gear handle believing the gear was down. Flaps were lowered to…Accident 20061120027869APiper PA28235 · Wellington, IL(-23) On November 20, 2006, at 1725 central standard time, a Piper PA-28-235, N8990W, piloted by a private pilot, was destroyed during an in-flight collision with terrain near Wellington, IL. The flight was being conducted under 14 CFR part 91 without a…Accident 20061120025649AUnivar 1081 · San Jose, CA(-23) The pilot in command departed reid-hillview airport (rhv) at approximately 12:15 PDT and made one circuit around the pattern. He then departed the airport and flew approximately 10 NM southeast, turned around and headed back to the airport. As he was…Incident 20061119030119IPiper PA23250 · Fond Du Lac, WI(-23) On November 19, 2006, at 1015 dst, at Fond Du Lac airport (fld), the pilot [privacy data omitted], a private pilot, [privacy data omitted] attempted to land a Piper aztec multiengine airplane, N5009Y, when the aircraft landing gear was not extended and…Accident 20061119029289ACessna 172RG · San Diego, CA(-23) On 11/19/06, a Cessna 172RG, N28RG, was substantially damaged when the landing gear collapsed during the landing roll on runway 28R at Montgomery Field Airport (myf) San Diego, CA. The pilot and three passengers were not injured. The airplane sustained…Accident 20061119027579APiper PA28140 · Grand Canyon, AZ(-23) Pilot and two passengers departed kingman, AZ at approximately 1100 local time on a pleasure flight to Valle, AZ. On initial approach to valley airport runway 1 pilot noticed winds were strong and aircraft was drifting to the left. Pilot initiated a…Accident 20061119024989ACessna 172S · New Smyrnabeach, FL(-23) The pilot was a student pilot on his first solo, first landing. He had two dual flights that day and was released for a supervised solo at new Smyrna Beach airport on runway 2. It was reported from eye witness the aircraft bounced twice and then nosed…Accident 20061119023759AAmtr RV6A · Midway, GA(-23) Pilot attempted to land beyond halfway down a 2,378 ft grass strip, marginally bumpy, first attempt in this particular aircraft. Short gear caused nose wheel to repeatedly lift off ground. Brakes were applied causing nose to contact ground with enough…Accident 20061119022999AAmtr LIBERTYXL2 · Albuquerque, NM(-23) On November 19, 2006, at 1040 MST, a liberty aerospace XL-2, N531XL, registered to [privacy data omitted] and operated by del sol aviation, had a hard landing at the Double Eagle II Airport, Albuquerque, new Mexico, while on a solo training flight.…Incident 20061118029869IPiper PA46500TP · Fort Wayne, IN(-23) Departing bloomington airport, (bmg), bloomington, IN., without incident, to Smith field, (smd) Fort Wayne, IN., the pilot extended the landing gear for landing. Pilot found MLG to indicate down, locked and safe. Upon landing on runway 5 at smd, the…Incident 20061118029859IPiper PA34200T · Peoria, IL(-23) [privacy data omitted] on approach to pia, pilot selected gear down but did not receive a lt. main gear down and lock indication. Pilot cycled gear to no avail. Pilot informed the tower and the tower reported back to the pilot that the gear appeared to…Accident 20061118029609AStumpj EXEC90 · Manchester, NH(-23) N169JS with pilot and passenger was enroute from mht to ash at 1000 ft approximately 4 miles northwest of mht. There was a large puff of blue smoke exterior of the craft with a small of burning oil in the cockpit. The pilot spotted a field a mile away,…Incident 20061118028049IAmtr EXEC162F · Oxford, ME(-23) The pilot aborted the takeoff after reaching approximately 50 knots airspeed because of a high rotor RPM indication. During the touchdown segment, the aircraft touched down hard on the aft skids with the tail low. The surface that the aircraft contacted…Incident 20061118026239ICessna T210G · San Jose, CA(-23) The pilot departed truckee, CA for mineta international airport at San Jose, CA. Prior to landing the pilot extended the landing gear but did not get a nose landing gear down indication. The pilot troubleshot the landing and continued to approach the…Accident 20061118026029AAmtr Varieze · Punta Gorda, FL(-23) On November 18, 2006, at 9:20 am local time, a Varieze (amateur built), N75EZ, registered to the pilot [privacy data omitted] collided with the ground after a report of the canopy partially opening, at Charlotte County Airport (PDT) in Punta Gorda,…Accident 20061118025699ASnias AS350BA · Fort Myers, FL(-23) On November 18, 2006, at 0920 EST, a Eurocopter AS-350, registered to lee county sheriff office, experienced ground resonance during start-up prior to takeoff for a local part 91 flight. Visual meteorological conditions prevailed at the time and no…Accident 20061118024189ACessna 170B · Billings, MT(-23) Directional control lost during touch-and-go landing; aircraft ground-looped. Directional control lost during takeoff following stop and go landing. Pilot stated he applied power, a/c yawed to left approx 30 deg (approx 8 kt crosswind component), he…Incident 20061117030259IDorner DO328300 · Milwaukee, WI(-23) On November 17, 2006, at 1745CST, at Milwaukee General Mitchell airport (mke), S2YA flight 2278, a dornier 328 jet, N352SK, landed on rwy 25L. When the nose gear made contact with the rwy it broke off a piece of concrete from the rwy, the concrete piece…Incident 20061117030109IPiper PA28R180 · Marion, OH(-23) Enroute from duh, PIC scanned instruments and found voltage meter to read 0 volts. Made decision to land at nearest airport which was mnn. Attempted to contact mnn via 2 comm frequencies but was unable to reach anybody. Enroute to mnn, aircraft…Incident 20061117029109IBeech J35 · Smoketown, PA(-23) Pilot stated that he landed gear up during a VFR approach into Smoketown Airport (S37). During the flare the pilot heard a warning horn and assumed it to be the stall warning. The pilot realized after contact with the runway that it was the gear warning…Incident 20061117026149IAmtr Glastar · Mesa, AZ(-23) On 11/17/2006, the pilot [privacy data omitted] was flying his Glastar N46776 s/n 7025 with a test pilot to evaluate problems with the aircraft's horizontal situation indicator (h.s.I.). The two noted the engine was running rough; this prompted a…Incident 20061117026099IBell 206L3 · LA(-23) During cruise flight, bird struck aircraft, which destroyed passenger windscreen causing a loss of tailrotor thrust. Pilot landed aircraft in water without incident.Accident 20061117025559ABeech J35 · Flagstaff, AZ(-23) On November 17, 2006, at about 19:30 mountain standard time, a Beech J35 airplane, N8246D, lost engine power, and impacted a tree on final approach for runway 21 at the Flagstaff Pulliam Airport (flg), Flagstaff, Arizona. The private pilot who was the…Incident 20061117024439IAmtr Longez · Orlando, FL(-23) Pilot was returning from the williston municipal airport VFR when he failed to follow his established procedure of lowering the nose gear prior to entering the pattern. Upon touch down the pilot lowered the nose of the aircraft to the runway and skidded…Accident 20061117024122AAmtr LC41550FG · Somerville, NJ(-23) The LC41 pilot was on the landing rollout to runway 30 at the Somerset Airport (smq) when he observed a small tractor towing a Piper saratoga across the runway from left to right. The pilot stated he did not see the saratoga until the nose wheel on his…Accident 20061116024559ACessna 172G · Ankeny, IA(-23) Aircraft was attempting to land at the Ankeny, IA airport (ikv) at approximately 1800 local time. The pilot was unable to get the pilot controlled runway lights to illuminate during her first landing attempt and initiated a go around. On the second…Accident 20061115029469AMaule MX7180B · Edenville, MI(-23) Aircraft was reported upside down in wixom lake. Aircraft was inspected at the gladwin county airport and was found to have apparent impact damage from water. The pilot who was the sole occupant was a fatality.Incident 20061115028449IPiper PA24250 · Norfolk, VA(-23) The pilot [privacy data omitted], pilot in command was cleared for landing after he made a visual of the runway at approximately 3000 ft. the pilot [privacy data omitted] stated while he was descending at 1200FT/minute, he failed to put the gear in the…Incident 20061115027839IGulstm 500S · Nogales, AZ(-23) During an approach to Nogales airport AZ. The pilot reported a straight in to runway 3. The airport UNICOM had told the pilot that the approach was for emergencies only. The pilot stated that he is declaring an emergency. This put him in a position of…Accident 20061115027229AGrob G103TWNASTIR · Tucson, AZ(-23) During the landing phase, pilot lost control of aircraft just before touchdown. Aircraft experienced pilot induced oscillations near the ground, and when the tail struck the ground it separated from the fuselage just ahead of the vertical stabilizer.…Incident 20061115027059ICessna U206E · Queens Bess, LA(-23) Pilot made a landing in an open bay at a remote seaport location (Queens Bess) and taxied into an adjacent canal and then to a nearby boat to offload a passenger. After approximately half an hour, the pilot and another passenger (non revenue) then…Accident 20061115025089ARobsin R44RAVENII · Baltimore, MD(-23) On November 15, 2006, at 1441 eastern standard time, a Robinson R44 ii, N74578, was substantially damaged when it impacted a parking lot following an attempted landing on a shipping trailer at the port of Baltimore, Baltimore, Maryland. The certificated…Incident 20061115024829ICessna P210N · Santa Rosa, CA(-23) Pilot was doing full stop landings to get night current. On the third landing he used his check list down wind and gumps, but still forgot to put the gear down.Incident 20061115024789ICessna 182A · Bethel, AK(-23) Engine began running rough while enroute to Bethel. Aircraft had engine failure approximately 3.6 NM north west of Bethel. Pilot suspects carburetor icing caused engine to quit.Accident 20061115023439AAviat A1B · Heber City, UT(-23) After about 2.5 hours of flight conducting a sar mission the pilot elected to land for a break. The sar command post was located in the vicinity of strawberry resevoir, UT. The existing normal roads were unusable due to posts along the side to aid the…Accident 20061114029419AMooney M20J · Akron, OH(-23) Pilot lost control of aircraft during landing at cak and crashed between rwy 19 and twy bravo next to B1 int. Cak radar tracking data indicate aircraft was executing a right turn into rwy 19 at a slow airspeed and low altitude.Incident 20061114028949IBlanca 1731ATC · Willimantic, CT(-23) Pilot lost control of aircraft during normal landing runway 09. Aircraft veered left, departed runway, crossed grassy infield and came to rest on taxiway.Incident 20061114027079IPiper PA28RT201 · Plymouth, FL(-23) On November 14, 2006 at approximately 1700 hours local time, a Piper arrow iv, registration N2895L, contacted the runway surface at orlando, apopka airport (X04) with the landing gear unintentionally in the retracted position. The flight instructor and…Incident 20061114025179IDoug MD11F · Dallas-Ft Worth, TX(-23) This office received a phone call from dfw ATCT informing that ups MD-11 had struck its tail upon landing at dfw. Three geographic inspectors from this office inspected the aircraft. Aft lower fuselage had evidence of scraping on the runway. Aft lower…Accident 20061114025039ACessna 421B · Big Bear City, CA(-23) The pilot records have not been located, and pilot information cannot be completed. The aircraft impacted the ground on the bank of big Bear lake. This report will be updated as information is available.Accident 20061114024199AAmtr Murphyrebel · Wimauma, FL(-23) On November 14, 2006 at 1700 hours eastern daylight time, a murphy experimental airplane, N4038W, registered to and operated by the pilot [privacy data omitted] under part 91, turned over aircraft upon landing at Wimauma, Florida. Visual meteorological…Accident 20061114024159APiper PA28140 · Caldwell, ID(-23) Aircraft landed short of runway 30 at the Caldwell, Idaho airport in a very soft field. Although the aircraft remained upright, the landing gear sunk deep into the mud and caused substantial damage to the wings and fuselage. The aircraft had departed…Incident 20061113030149IBeech C90 · Minneapolis, MN(-23) The pilot [privacy data omitted] was acting as a part 135 flight instructor, conducting pattern work with an initial new hire. Neither pilot remembered to put the gear down, and a last second waveoff by ATC allowed a rejected landing, but not before the…Incident 20061113027399IBnorm BN2AMK3 · San Juan, Puerto Rico(-23) On November 13, 2006, at approximately 1630 local time, apelair (A6PA) aircraft N650LP, while landing at Luis Marin international airport (sju) in San Juan, puerto rico runway 8, the left main landing gear rotated to the left making the aircraft get off…Accident 20061113026879ACessna T303 · South Bend, IN(-23) The twin Cessna aircraft departed sbn airport on an IFR flight plan at approximately 7:56 pm EST with five people on board, including the pilot. Air traffic control (ATC) interceded to aid the pilot in getting established on the intended route of…Incident 20061113025229ICessna 310F · Thomaston, GA(-23) The pilot stated that he had just picked the aircraft up from the annual inspection and flew to his home base. Upon arrival, when he attempted to lower the landing gear, he did not get a green light, safe gear indication. Airport and maintenance…Incident 20061113024799IDoug C47 · Houma, LA(-23) Aircraft departed Houma airport on a local training flight and flew to the nearby Houma-Terrebonne VOR to practice holding. Shortly thereafter, the crew noticed the oil temperature rising and the oil pressure falling on the right engine. The crew…Accident 20061113024619AAmtr KOLBMK3 · Paulden, AZ(-23) Unknown pilot in command (two Pilots) were accomplishing touch and go landings (witness statements). During this approach the aircraft apparently stalled at low altitude and crashed. *the pilot [privacy data omitted] received a sport pilot certificate…Accident 20061113024169ABell UH1H · Melrose, NM(-23) On 11/13/2006, at approximately 1115 MST, during cruise flight on a VFR cross country flight from fort lauderdale, Florida, to albuquerque, new Mexico, flying at approximately 800 feet AGL, the crew of N24CF, a Bell helicopter, model UH-1H, experienced…Accident 20061113023779ABlanca 1730 · West Palm Beach, FL(-23) On November 13, 2006, about 11:38 eastern standard time, a Bellanca BL-17-30, N6663V, registered to and operated by a private individual crashed in a house and car. The pilot stated he took off from lantana airport (lna) rwy 33 and completed one touch &…