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 20080902845249ARobsin R22BETA · Refugio, TX(-23) On September 2, 2008, at approximately 1530 CST, a Robinson, R-22 beta helicopter, N2312E, sustained substantial damage when the main rotor struck the tail boom after making a hard landing during a wildlife aerial survey flight on a ranch near Refugio,…Accident 20080902844359ACessna R182 · Denver, CO(-23) On 09/02/2008 at approximately 11:25 am a Cessna R-182, N756TK, experienced a prop strike while the pilot, a certified flight instructor candidate, was practicing crosswind takeoffs and landings. VFR meteorological conditions existed at the time of the…Incident 20080902843629IValent TAIFUN17E · Gallup, NM(-23) On September 2, 2008 at 1310 MDT, a Valent 17-E motor glider, N65MA, registered ot the pilot, impacted terrain during takeoff from Gallup Municipal Airport in galup, NM. Visual meteorological conditions prevailed at the time, and no flight plan was…Incident 20080901855799ICessna 208B · Orlando, FL(-23) N862FE, a Cessna 208B was being operated single pilot by mountain air cargo, a contract operator for fedex. The aircraft was on a IFR repositioning flight from kism to kfll. Following climb-out at 2000 MSL, pilot heard a loud clicking sound. During that…Incident 20080901851289IColumb LC41550FG · Martinsburg, PA(-23) Aircraft experienced loss of power and the pilot executed a safe landing at aoo while enroute from hpn to agc. Oil was noted on the underside of the fuselage and aircraft was towed from runway to penn-air hangar. Pilot noted that one quart of oil was…Accident 20080901850279ACessna 172M · Three Lakes, WI(-23) On September 1, 2008, at 1528 CDT, the pilot of a Cessna 172M, N12809, was distracted by the pilot door coming open just after takeoff on runway 21 at Three Lakes Municipal Airport tree lakes, WI. The pleasure flight was conducted in visual…Accident 20080901845979ACessna 207 · Peede Mine, AK(-23) Pilot wanted to land past the first 1/3 of the runway because it appeared to be to rough. The pilot added power to extend his landing, floated then settled onto the runway. He then did not have enough runway remaining to stop, he applied power but did…Accident 20080901845599ACessna 560CESSNA · Telluride, CON839QS flew from sugarland, TX (ksgr) to Telluride, CO (ktex) on September 1, 2008. The flight landed at approximately 17:14 local time. The aircraft touch down at approximately 1,000 feet down on runway 9, which is congruent with aircraft debris found near…Incident 20080901845099ILkheed SP2H · Reno, NV(-23) On September 1, 2008 at approximately 6:10PM, N4235T departed Reno-Stead airport, 4SD, to perform an air tanker fire fighting operation. Upon departure, at approximately 400 feet above ground level, the left jet engine experienced a catastrophic…Incident 20080901844799ICessna 172M · Ashland, KY(-23) Student pilot had hard landing that bent and broke the rims of the nose wheel. This was the students forth solo flight.Accident 20080901844709AAyres S2R · D'Hanis, TX(-23) The aircraft lost engine power while making a third pass during aerial application. The pilot stated he put the aircraft into a high pitch attitude to clear a tree line. The aircraft hit some tree tops severely damaging the right wing, the belly…Accident 20080901844509ACvac 340580 · Columbus, OH(-23) Aircraft crashed shortly after takeoff. The aircraft, registration number N587X, an convair 340/580 operated by air tahoma (I5HA), depated runway 5L at Rickenbacker International Airport, in lockbourne, Ohio. The part 91 flight was intended as a…Accident 20080901844189APiper PA32260 · Cumberland, RI(-23) On September 01, 2008, at approximately 0830 (EDT), a Piper PA-32-260, N5529J being flown by a private pilot on a personal trip made an off-airport emergency landing. The aircraft sustained substantial damage. The pilot of the aircraft stated in a…Incident 20080901843659IBeech A36 · Grand Island, NE(-23) After pre-take off run-up, pilot clipped taxi light while taxiing aircraft for take-off on runway 17. Pilot taxied aircraft back onto taxiway. Pilot shutdown engine and examined aircraft. Pilot found one prop blade tip damaged from hitting a taxiway…Accident 20080831855489ACamron ZL60 · Anderson, SC(-23) Airman crashed his balloon while competing in balloon federation of america race. Pilot sustained major injuries and admitted to the Anderson, SC hospital. The balloon sustained substantial damage. The airman got confused at about 8000' MSL and could…Accident 20080831851939ACessna T310R · Export, PA(-23) Cessna N3180M, operated by [privacy data omitted] departed latrobe, PA (klbe) at approximately 0930 on August 31, 2008. The aircraft was destroyed and the pilot fatally injured at approximately 0940 on August 31, 2008. The wreckage was found five miles…Accident 20080831851439ACessna 340A · Angel Fire, NM(-23) At approximately 2045 MDT on August 31, 2008, the pilot of N397RA, the pilot of N397RA, a Cessna 340A, decided to go-around after executing the GPS 17 approach at Angel Fire Airport (axx), Angel Fire, NM. The pilot entered the left-hand pattern for a…Accident 20080831850729ABbavia 8GCBC · Fairbanks, AK(-23) Solo student pilot failed to maintain ground track and runway alignment on landing. Aircraft drifted left of the intended runway sustaining substantial damage after striking brushes along the left side the runway.Accident 20080831850339ABell 206L1 · Greensburg, IN(-23) On 8/31/2008 at approximately 1330 N37AE, a Bell 206-11 helicopter, registered to air evac EMS inc, departed a public relations event and crashed a short time later. All three occupants were fatally injured. The flight had originated at a hospital in…Accident 20080831850269AFantar ALLEGRO2000 · Walworth, WI(-23) On August 31, 2008, at approximately 8:00 cdlt a student pilot on roll out after landing big Foot airport, Walworth, WI lost directional control and entered a corn field that bordered the runway. The aircraft received substantial damage and the pilot…Incident 20080831849579IDehav DH82A · Warehouse Poin, CT(-23) According to the pilot the aircraft lost power on departure from runway 10 Skylark airport, Warehouse pt. CT. And settled into the trees about half a mile east of the airport at approximately 0930 EDT, 08/31/2008. The investigation revealed no injuries,…Incident 20080831847329IPiper PA22150 · Star City, AR(-23) On August 3, 2008, at 1015 central daylight savings time, a Piper PA-22-150 received substantial damage during landing at Star City Arkansas airport. The airplane was registered to [privacy data omitted] and operated by [privacy data omitted],…Accident 20080831846209ACessna 150J · Spring Grove, IL(-23)On August 31, 2008 at aproximately 1700 (l) N50753, a Cessna-150J taxied to runway 36 at pillow hill airport (3LL4). Pillow hill airport is located in Spring Grove, Illinois and has one north/south turf runway. After departure, N50753 impacted a tree…Accident 20080831845569APiper PA18 · Camarillo, CA(-23) On 08/31/2008 at 0922 while attempting to pick up a banner N7482D a PA-18 made a low and flat approach, then proceeded to snagged the banner pick up rope around the amin landing gear. The aircraft was climbing out of the pick-up at 200 feet AGL. The…Accident 20080831844919ASchler ASW20B · Cleburne, TX(-23) At approximately 1430CDT a passing motorist notified a local resident that the aircraft had crashed. The local resident was the first person on-scene and was a 23 year veteran of Cleburne fire dept who was off duty and lived across the road from the…Accident 20080831844769ALOEHLEP40 · Oregon City, OR(-23) The pilot left aero acres airport and flew for 45 minutes when the engine quit and he landed at a farm to south of the airport. The pilot refueled the aircraft and checked the condition of the aircraft. He then preceded to take off in the aircraft from…Incident 20080831844269ICamron A140 · Bentonville, AR(-23) On August 31, 2008, at approximately 0745 CST, N10731, a cameron balloon, while aborting a landing came in contact with a building. The pilot reported that he experienced a sudden change in wind direction. There were no injuries to the pilot or…Accident 20080831844149APiper PA22150 · Dillon, MT(-23) On August 331, 2008, at approximately 12:00 noon, N4143D landed on runway 2 at Dillon Airport, (dln), Dillon, Montana. The flying pilot lost contorl of aircraft on landing;the owner/instructor pilot took over the controls and regained control of the…Incident 20080830855659IAerost YAK52 · Sewall, FLExperimental aircraft N524CK was flying back to witham field, stuart, Florida, when he smelled a strong fuel odor, engine sputtered and then stopped. Pilot was unsuccessful in attempts to restart engine and could not make it back to the airport at which point…Incident 20080830855649ICessna 414 · Savannah, GAWhile operating aircraft for intent for personal flight under VFR conditions and attempting to takeoff on runway 36, aircraft collided with signs while maneuvering following right landing gear brake failure. The aircraft sustained minor damage and the pilot…Accident 20080830855479AAmtr Mxlii · Carceloneta, PROn August 30, 2008, around 1300 hrs, the FSDO in san juan, PR was notified by [privacy data omitted] the owner of the aircraft N594TC of an accident which occurred in barceloneta, puerto rico, the pilot in command was [privacy data omitted], no. [privacy data…Accident 20080830849769APiper PA22135(-23) Airman stated that this was the first time he had landed at that strip with another person onboard. The higher speed required with an additional person onboard resulted in a longer than anticipated roll out. The aircraft rolled past the end of the strip…Accident 20080830849429ACessna 182A · Elizabethtown, KY(-23) On August 30, 2008, at 1857 EDT, a Cessna 182A received substantial damage resulting from the engine quitting and landing short of runway 5 at ekx, Addington Field, in Elizabethtown KY. The aircraft was being operated under VFR conditions, 14 CFR 91.…Accident 20080830848089ADhav DH82A · Sevierville, TN(-23) It appears that the propellar lost it's brass tip cap on takeoff. See attached pilot's statement. Engine inspection and disassembly could find nothing wrong with the engine. During landing attempt aircraft encountered a ditch in field, landing gear…Accident 20080830846609ACessna U206G · Galena, AK(-23) The pilot stated that he departed wasilla lake for a 14CFR part 91 flight to the kobuk region. Approximately 63 miles east of Galena, AK he began to smell fuel and noticed the fuel flow begin to fluctuate. He stated he began to look for a suitable…Accident 20080830846129ACessna 150 · Bay City, MI(-23) Aircraft departed a private airport at milington, MI for Bay City. The aircraft lost power 2 miles from the runway at Bay City and landed short in a corn field. The nose wheel was sheared off and the firewall and engine mount were damaged. The pilot was…Accident 20080830845129ACessna 172 · Newton, MS(-23) Pilot stated nose gear collapsed upon landing. Nose gear had collapsed. Right main landing gear was bent upward and aft. Damage was noted on the right wing tip. Damage noted on underneath and right side of fuselage.Incident 20080830844789ICessna 402C · Boston, MADuring taxi to the ramp the aircraft's left wing struck a parked cape air aircraft, scraping the lower side of the left elevator. The taxiing aircraft incurred damage to 5 vortex generators located on the top side, outboard end, of the left wing. The parked…Accident 20080830844489ASwrngn SA227AC · Carlsbad, NM(-23) On 08/30/2008 at approximately 14:50 pm, airplane N2699Y, a fairchiled SA227-AC, serial number AC-666, operated by a airline transport pilot, while performing a non-revenue repositioning flight (MDS263) from el paso, TX (elp) to tyler, TX (tyr) for 14…Accident 20080830844289ACessna T310R · Seeley Lake, MT(-23) On August 30, 2008, at approximately 2158 MDT, a Cessna T310R, N4914, registered to [privacy data omitted], struck and killed a deer with the right main landing gear shortly after takeoff at the Seeley Lake, Montana (23S) airport while on a personal…Accident 20080830843799AMooney M20C · Lawrenceburg, TN(-23) Witnesses stated the aircraft was missing, running rough or had quit prior to the accident. Investigator [privacy data omitted], NTSB reported that only small quantity of fuel was found in the system. The tanks were tested by filling them with water and…Incident 20080829855659IBeech 23 · Zephyrhills, FL(-23) Non-rated student pilot had repositioned the aircraft to the refueling ramp and was returning to parking. As he approached his spot and applied the brakes to stop, the aircraft continued and ran into the untralite aircraft parked beyond his spot.Incident 20080829855629IGulstm 112A · Boca Grande, FL(-23) On August 29, 2008 at approximately 1108 EDT a rockwell international 112A s/n 435 registered to private owner [privacy data omitted] landed in the gulf of Mexico approximately 150 feet off the shoreline at 4043 shore lane, Boca Grande, Florida 33921.…Accident 20080829855549AUnivar 415C · Sebring, FL(-23) On August 29, 2008, at approx. 12:15 EST, an Ercoupe 415-C hit a bird at approximately 1300 feet, the wood prop splintered and engine started heavy vibration. The pilot landed in an open field and hit a drainage ditch which was unseen which caused the…Accident 20080829848099AScwzer G164B · NC(-23) [privacy data omitted] reported he had departed his private strip with approximately 200 gallons of chemicals to complete one last application for the day due to clouds and rain moving into the area. Due to the rain and clouds [privacy data omitted] was…Accident 20080829845779ACessna 172N(-23) On August 29, 2008, at approximately 1856 PDT, N172ST, a Cessna CE-172N crashed on clybourne ave, approximately one half mile west of runway 15 centerline, at bob hope airport (bur), burbank, CA. The accident pilot rented this aircraft from universal…Incident 20080829845699IBoeing 747251B · Victorville, CA(-23) Shortly after takeoff, the nr 4 engine fire warning light illuminated, and the nr 4 engine nacelle temp gauge indicated into the red zone. The crew discharged the nr 4 fire bottle, dumped fuel, and returned safely to kvcv. There was no emergency…Accident 20080829845499ACirrus SR22 · Black Rock Cit, NV(-23) Aircraft rotated to takeoff attitude and lifted off without sufficient speed to remain airborne. The aircraft settled and contacted the ground off the left side of the runway. The longitudinal axis was not aligned with the direction of travel at ground…Accident 20080829845269ADHC2 · Talkeetna, AK(-23) Pilot attempted a takeoff in a DHC-2 beaver from a narrow, brush-lined, airstrip approximately 35 miles west of Talkeetna, AK. During the takeoff roll the left wing contracted the high brush causing the aircraft to veer to the left into the brush. Pilot…Accident 20080829845049ARobsin R44 · Point Lookout, MO(-23) Prior to this accident, the new Robinson R-44 helicopter was being flown on a ferry flight from torrance, California to mattoon, Illinois. According to witness statements, the helicopter was flying in a straight level configuration when they heard an…