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 20060626017269ABeech 3533 · Lincoln, NE(-23) IFR flight from amarillo TX to Lincoln NE. A private pilot with no high performance endorsement in the left seat, and a commercial pilot with an instructor rating in the right seat. The airplane had a single throw over yoke. Pilot planned on a 3 hour…Incident 20060626015439ICessna 210L · Dekalb, IL(-23) The pilot [privacy data omitted] made a normal VFR approach at Dekalb muniicipal airport, Dekalb, Illinois, in Cessna 210, N4688Q, on June 26, 2006. He failed, however, to lower the landing gear before landing. The airplane sustained minor damage as it…Accident 20060626014029APiper PA18150 · Minong, WI(-23) On final approach to Minong, WI, the pilot decided he was out of position and initiated a go around. Pilot stated he applied power and pulled the nose up. As the aircraft pitched up the pilot moved the stick forward to level the aircraft out but could…Incident 20060626013239ICessna A188B · Meade County, KS(-23) On June 26, 2006, N8206G, a Cessna 188, piloted by [privacy data omitted], holder of commercial certificate [privacy data omitted], struck a power line while conducting a spray operation. The pilot [privacy data omitted] had sprayed round-up on his…Incident 20060626012719IPiper PA24250 · Perry, FL(-23) On June 26, 2006, at 1650 EDT, a commanche model PA-24-250, N41L, piloted by [privacy data omitted] landed gear up at Perry Foley municipal airport, Perry, Florida. The pilot was on a cross country flight that originated at memphis municipal (fye).…Incident 20060626012369IBoeing 757251 · Las Vegas, NV(-23) Las-dtw, returned to las due to a pressurization problem and that 12 pax had heat and ear injuries. NTSB determined injuries to be minor and later confirmed by nwaa to be minor.Accident 20060625030789ACessna T210M · Hayward, CA(-23) After runup in the parking area, aircraft taxied and made a normal takeoff. At approximately 250 feet AGL, the engine lost power and the aircraft descended, struck a fence and then a tree and came to rest on a golf course adjacent to the airport.Accident 20060625022299ACessna 182K · Center Island, UT(-23) Aircraft landed long about 1/3 way down a 1600' runway, went off end of runway, nose gear collapsed, aircraft flipped over on its back.Accident 20060625020829AVarga 2150AMORISY · Columbus, WI(-23) On June 25, 2006, at 0952 CDT, a Varga 2150-A, N8267J, registered to and piloted by [privacy data omitted] collided with trees along the crawfish river at astico county park, dodge county Wisconsin. The VFR pleasure flight originated at capitol drive…Incident 20060625016259ICessna T210M · Hayward, CA(-23) After parking the aircraft and while the engine was still running for turbo cool-down, the right seat passenger exited the aircraft and walked straight forward into the propeller.Incident 20060625015219IBeech V35 · Detroit/Grosse, MI(-23) Aircraft landed with landing gear in the retracted position.Incident 20060625015139IAmtr RANSS6ES · Leech Lake, MN(-23) Pilot attempted to land his amphibious float equipped experimental amateur built aircraft on Leech Lake, MN, with the wheels down. When the wheels contacted the water the aircraft flipped over and sank. No injuries were noted.Accident 20060625014639AMaule M7235C · La Verne, CA(-23) On June 25, 2006, about 0900 pacific daylight time a Maule M-7-235C, N209Z, veered off the runway and nosed over during landing at Brackett field, laverne, California. The pilot [privacy data omitted] was operating the airplane under provisions of 14…Incident 20060625014409ICessna 180 · Anchorage, AK(-23) While landing in gusty crosswind conditions, aircraft ground looped and received damage to the right wingtip and right tire/wheel assembly. There were no injuries reported by the pilot or his two passengers.Accident 20060625014099AMtsbsi MU2B60 · Fort Pierce, FL(-23) On 25 June, 2006, N316PR, a MU-2, piloted by [privacy data omitted] took off from runway 14 at st. Lucie county int'l airport (kfpr) at 1623Z enroute to murfreesboro, TN (kmbt). The aircraft was issued a heading of 090 by Fort Pierce air traffic control…Accident 20060625013289ABbavia 7KCAB · Carlsbad, CA(-23) Aircraft lost control after landing and went off right side of runway, over a fence, and came to rest on a tree.Accident 20060625012979APiper PA28140 · Walworth, WI(-23) Thunderstorms in area/windshift. *aircraft was attempting to land "downwind" runway 36 big Foot airport (7V3) *pilot realized he was "long" and could not stop *"go around" was initiated *aircraft struck vehicle on adjacent road *after impact with…Accident 20060625012949APiper PA34220T · Tafton, PA(-23) The aircraft departed gso on 06/25/06 at 1015 local time enroute to sfm on an IFR flight plan with full fuel and three people onboard. Radar data indicates the aircraft was on a northeasterly heading at 6,900 feet over Tafton, PA in instrument…Accident 20060624022579AAmtr Renegade II · Orneville, ME(-23) On June 24, 2006, at 1926 eastern daylight time, a Renegade II, experimental aircraft, N536N, was destroyed by a post crash fire when it impacted a tree and fell to the ground after attempting an emergency landing due to a loss of power. The…Incident 20060624016809IBeech 95B55 · Titusville, FL(-23) On 24 June 2006, the pilot [privacy data omitted] experienced a nose landing gear collapse upon landing on runway 27 at Titusville, FL (ktix). Pilot stated he took off from runway 22 (3412 feet) at cherokee county airport, canton, ga (47A; field…Accident 20060624014299ACessna 170A · Atwood, IL(-23) The pilot of N9204A reported that while approaching a private airport north of Atwood, Illinois for landing, and while still approximately three miles from that facility, the engine lost power for unknown reasons. The pilot elected to make an off…Accident 20060624014089ALuscom 8A · Bowling Green, MO(-23) After takeoff from runway 31, the pilot began a left turn at approximately 1400 MSL (514' AGL). He reported hearing 4 or 4 seconds of loud knocking which was followed by a sudden propeller stoppage. The aircraft landed on a southwest heading and slid on…Accident 20060624012909AMiller CRICKETMC12 · Lee'S Summit, MO(-23) The twin-engine experimental airplane was operating in the traffic pattern for runway 18 at Lee'S Summit Municipal Airport (lxt), Lee'S Summit, Missouri. Witnesses reported hearing an engine running rough (cutting out) and observed the aircraft low on…Accident 20060624012169APilats PC1247 · Big Timber, MT(-23) On June 24, 2006, at 1420 MDT, a Pilatus PC-12/47, N768H, registered to jmh capital LLC, collided with terrain approximately 1.5 miles east of the Big Timber, Montana airport while on a training flight. The Pilatus crew advised that they would be…Accident 20060624011949ACessna 560CESSNA · Upland, CA(-23) N486SB, CE-560, crashed at the end of the runway at Cable Airport. Aircraft completely destroyed on impact. Three occupants including pilot were severely burned and transported to area hospitals. Eye witnesses reported seeing the aircraft landed long.…Accident 20060624011859AMooney M20F · Parowan, UT(-23) Flying close to mountains and encountered downdraft, unable to establish climb due to downdraft.Incident 20060624010709ICessna 172M · Galveston, TX(-23) Pilot stated that he refueled the aircraft and tried to start the aircraft but it would not start. After several attempts he decided to hand prop the aircraft. He hand propped the aircraft which started and accelerated while the pilot was trying to get…Accident 20060623029189APiper PA23250 · Borinquen, Puerto Rico(-23) According with the pilot's [privacy data omitted] accident report statement dated 28 June 2006, he departed "VFR" from ft. lauderdale (kfll) direct to st. thomas (tist), it appears that the pilot's [privacy data omitted] aircraft encountered a fuel…Accident 20060623016959AGulstm 112TCA · Sarasota-Braden, FL(-23) Aircraft departed Sarasota airport with insufficient fuel to reach its destination airport. Immediately after initial climb and level out at 1600 feet the engine lost power and began to run rough. The pilot attempted to return to Sarasota airport but…Incident 20060623016689IPiper PA28140 · Sarasota, FL(-23) On June 23, 2006, at 1115 EST, a Piper 28-140, N333KQ, operating on a personal flight, experienced engine power loss at cruise altitude and landed safely on an unpopulated road in Sarasota, Florida. Visual meteorological conditions prevailed at the…Incident 20060623015269IBlanca 1730A · Minocqua/Woodru, WI(-23) Pilot stated everything normal for landing set up. He thought he put the gear down but doesn't remember for sure. When asked if he heard a gear warning, he stated that the warning in this aircraft is more like a chime than a warning horn. He stated that…Incident 20060623014589ICessna 172S · Flagstaff, AZ(-23) Pilot was on a solo cross-country from scottsdale, AZ to Flagstaff, AZ. After landing at Flagstaff while taxiing to parking the student pilot hit another aircraft with his wing tip.Incident 20060623014429IBell 206B · Patterson, LA(-23) During cruise, pilot experienced engine power loss, executed emergency landing procedure and safely landed in a marsh area with external floats deployed to avoid a/c damage. "Air leak" detected at "P4" line connection to the engine fuel control unit and…Incident 20060623012839IBeech J35 · Camas, WA(-23) During approach the pilot selected landing gear down. Pilot did not verify that the gear was down by the gear down indicator. Aircraft landed with gear up. Pilot noticed that the landing gear circuit breaker was "popped" after the incident.Incident 20060623012739ICessna T206H · Root Ranch, ID(-23) Landed long and ran off the end of the runway into a bog/river. Damage to propeller and cowl panel. Damage minor. (-23 amendment) owner was participating in a 5 day seminar to hone back country flying skills. Seminar provided by [privacy data omitted]…Incident 20060623012709IGoldbe Aviprobearha · Denver, CO(-23) After landing, the tail wheel on this home-built aircraft was unresponsive to control inputs as the aircraft rolled out. The aircraft left the runway and stopped. Tail wheel subsequently replaced.Accident 20060623012189APiper PA25235 · Miami, FL(-23) On June 23, 2006, at approximately 1420 hours, a PA-25-235 operated by aerial banners, inc. crash landed at opf. According to witness, the aircraft had just refueled and proceeded to taxi west on tango, entering runway 12-30, via gulf taxiway for…Accident 20060623011759ABeech C90 · Windsor Locks, CT(-23) FAA king air, N20, BE-90, 06/23/2006, 1237 EST, Bradley International Airport (kbdl) was on a currency/proficiency flight. The flight originated in portland, Maine at 15:05 UTC with the intent to bring the aircraft to the Windsor Locks, CT flight…Accident 20060622022619ACessna 172N · Newry, ME(-23) Portland FSDO notified of accident at Newry, Maine on or about 1700, 6-22-06. Portland inspector [privacy data omitted] dispatched to accident scene arriving at scene at approximately 7:30 pm on 6-22-06. Accident team dispatched to scene at first light…Accident 20060622019059ACessna R182 · Lebanon, TN(-23) Inspector's statement: June 22, 2006, I went to investigate an accident at Lebanon, TN (M54) Cessna 182 rg s/n R18201911 N6124T. The pilot [privacy data omitted] was unable to get the landing gear into a locked position, due to total loss of system…Incident 20060622015359ISaab 340B · Detroit, MI(-23) While at the gate and during passenger boarding, ground personnel advised flight crew that the cargo bin appeared to be filling with smoke. Flight crew then noticed a smell as if something was burning. Electrical power was turned off and disconnected.…Incident 20060622015259IPiper PA28161 · Grand Forks, ND(-23) On 06/22/2006 at 1328 CDT, a PA-28-161, N239ND, owned by the university of north dakota and flown by the pilot [privacy data omitted] lost directional control upon landing at Grand Forks int'l airport, ND. The student pilot and sole occupant was…Accident 20060622015179AWthrly 201B · Bowbells, ND(-23) Pilot was applying herbicide to pasture land with general topography of hills and valleys. After completing a westward run, pilot turned southward and was unable to clear a hill that was approximately 500 feet higher than the surrounding terrain. The…Accident 20060622014289ABolkms BK117A1 · Westville, FL(-23) The landing zone in use had been surveyed and preapproved for use by the air carrier and county officials. The lz had been dug up and graded in preparation for resodding. Neither the county or the operator were aware of the construction until the…Accident 20060622013609ACessna 152 · Concord, CA(-23) The student pilot was on his first solo from ccr, during the landing phase the student got distracted by a nearby grass fire and was set up incorrectly for the landing. He came in fast and hit hard on the mains, the aircraft then hit on the nose gear at…Accident 20060622012879AAmtr Challengerii · Emmett, ID(-23) Uncertificated pilot took off from an airport in an unregistered, uncertificated aircraft with the flaporons fully extended. The aircraft climbed to 100 feet but began to settle back to the ground. Attempts to adjust the flap setting were difficult…Accident 20060622012509ABornho Sportjet · Colorado Sprin, CO(-23) This aircraft impacted terrain after takeoff from runway 17R approximately 90 seconds after a Dehavilland dash 8 aircraft departed from the same runway. Wind was approximately 6 knots from the east. The aircraft was airborne only momentarily after…Accident 20060621031319ACessna 172S · White Plains, NY(-23) On 06/21/2006 at approximately 1706 hours EST, this aircraft landed on runway 29 and hpn airport and after landing overran the runway and came to rest on its nose into a ravine. The pilot exited the aircraft without injury. The aircraft sustained…Incident 20060621016179IBeech 1900D · Las Vegas, NV(-23) Inspector statement: personnel of this office are investigating an incident occurring on June 21, 2006 involving the operation of a BE-1900D aircraft, N255GL. N255GL was being operated under FAR part 121 rules by scenic airlines, certificate number…Incident 20060621014499ICessna 210B · Canyon Lake, TX(-23) On June 21, 2006, at approximately 1215 central standard time, N9759X, a Cessna 210, sustained minor damage after the nose wheel collapsed after landing at the Canyon Lake Airport in fischer, Texas. The gear doors were damaged and the prop was bent. The…