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 20070722013679AScwzer SGS126C · Isle Of Wight, VA(-23) The pilot stated that on 07/22/2007, he departed garner field (3VA8) at 12:00 local time, was towed up to 3000' AGL and released. He climbed to 5200' and flew to smithfield, VA, then windsor, VA (southwest of 3VA8) then headed back to garner, VA. At…Accident 20070722013659ACessna TU206F · Nampa, ID(-23) The pilot was completing an aerial mapping mission and was returning ot the Nampa, Idaho airport (S67) during a VFR approach to landing runway 29 at S67. The pilot experienced an engine failure on the down wind leg. While on final approach the aircraft…Incident 20070721826689ICessna 210 · Belle Plaine, MN(-23) N9546T was receiving flight following from M98 enroute from STC to owa. Pilot advised he had a rough running engine and performed a precautionary landing in a farm field 4 miles NE of the 7Y7 airport located near Belle Plaine, Minnesota. Owner/operator…Incident 20070721825879IAmtr CH601HD · Rochester, IN(-23) The pilot and passenger made a full stop landing at Fulton County Airport to refuel. After refueling the pilot and passenger taxied to the approach end of runway 11 and started their take-off roll. According to the pilot he rotated the aircraft off of…Accident 20070721020119AAmtr Juniorace · Dover/Foxcroft, ME(-23) The pilot [privacy data omitted] (78 years old pilot) was flying for approx. 20 minutes and seen crossing the 44B airport to enter downwind but not seen again. He crashed on a short (1/8 mile) base to final turn to runway 27 (turf runway) at the 44B…Accident 20070721020009ABeech V35B · Chicago/Rockfo, IL(-23) Pilot explained that he experienced loss of power at 3,500 feet MSL near the greater Rockford airport (krfd). He immediately started to look for a suitable landing site. He chose a corn field about 5 miles north of krfd. Unfortunately the corn is about…Accident 20070721018079ALear 25 · St Augustine, FL(-23) On July 21, 2007, at approximately 1415 EDT, a Learjet 25, N70SK, serial #049, was substantially damaged during a hard landing at st. Augustine airport, st. Augustine, Florida. Crew reported both engines flamed out at 5000 AGL. The aircraft had departed…Accident 20070721017189AScwzer SGS126E · Elmira, NY(-23) On July 21, 2007 at approximately 1600 local time a Schweizer aircraft model 1-26E glider landed short of runway 34 at 4NY8 (Harris Hill, NY). The aircraft contacted the tree ridge line about 1/4 mile from the runway. The student pilot stated that he…Incident 20070721016879ISupac LCA · Louisville, KY(-23) The pilot stated that after touchdown, while rolling out, the landing gear collapsed at approximately 30 KTS. Biannual conducted by [privacy data omitted]Incident 20070721016499IAmtr Miniimp · Wilkes-Barre/S, PA(-23) As the pilot rotated the aircraft for takeoff, he felt something wrong in the drivetrain. He reduced power to abort the takeoff. The aircraft landed hard on the runway, and bounced up into the air again. At this point the pilot applied power to reduce…Accident 20070721015599AHughes 369D · Omak, WA(-23) On 07-21-07 at approximately 1615 hours local time, while dipping water for fire fighting operations, the commercial pilot allowed the tail rotor of the HU-369-D to strike the lake surface. After feeling a vibration in the helicopter, the pilot leveled…Accident 20070721015499AFound FBA2C2 · Crested Butte, CO(-23) Aircraft landing runway 32, touched down on the first few hundred feet of the runway, the airplane hopped a few times on runway, veered off to the left and off the runway, went down a slight embankment and spun around. Aircraft sustained severe damage.Accident 20070721014189ASwftms GC1B · Cottage Grove, OR(-23) Aircraft departed Cottage Grove airport to the south. Aircraft lost control approximately 1/4 of a mile off end of runway and crashed into an old mining pond and landed upside down in the water. The pilot [privacy data omitted] was found in the left…Incident 20070721013579IPiper PA11 · Burley, ID(-23) Pilot was enroute from lander, WY to Burley, ID. He ran out of fuel and landed in a potato field about 5 miles south and 1 mile west of rupert, ID which put him about 4 miles due east of the Burley, ID airport. The pilot indicated that he put 3:30…Accident 20070721012939ABoeing A75 · Spokane, WA(-23) During landing rollout, pilot claims brakes grabbed/locked and aircraft nosed over onto its back. No injuries, no fire. (-23 amendment) the pilot stated that he performed a normal landing and was on the roll out when he applied brakes. The right brake…Accident 20070720832429AFlight Ctsw · Daytona Beach, FL(-23) On July 20, 2007 [privacy data omitted] was enroute from harrisburg, pa (cxy) to spuce Creek, FL. The Flight was approximately 7 hours. During Flight through jacksonville, FL he noted a significant difference in fuel levels. Further into the Flight he…Incident 20070720826129ILakeac 250(Lake) · Coldwater, MI(-23) On the evening of July 20th, 2007, the pilot [privacy data omitted] took off from his residence at [privacy data omitted] with two passengers on board for a short sightseeing trip. They landed at branch county memorial airport in Coldwater, MI. For…Accident 20070720021789AAmtr M1 · Covode, PA(-23) Interviewed two witnesses, a nine year old amish boy, [privacy data omitted], and an amish woman, [privacy data omitted]. Both said the engine "sounded funny" and saw the aircraft west bound. They turned and heard an explosion and saw smoke but did not…Accident 20070720019869AScwzer SGS135C · Stanton, MN(-23) The pilot airman [privacy data omitted] encountered unexpected aerial downdrafts, which led to an off field glider landing, 4 miles from the intended airfield. During landing, the pilot airman [privacy data omitted] pulled nose up to avoid impacting…Incident 20070720019199IIca IAR823 · Auburn/Lewisto, ME(-23) Pilot reported upon landing, found that he forgot to put the gear down.Accident 20070720018459ACessna T188C · Colby, KS(-23) While taking off on runway 17 Colby (kcbk) to the south, with a crosswind from the east the aircraft started to weather vane. The pilot tried to correct by applying the right hand brake. The right hand brake failed to operate, the aircraft departed the…Accident 20070720017539AAmtr LANCAIR320 · Destin, FL(-23) During cruise flight from pensacola, FL (pns) to panama city, FL (pfn), aircraft experienced an in-flight separation of one propeller blade. Due to excessive vibration of the engine and propeller, the pilot shut down the engine, set glide and diverted…Incident 20070720016219ICessna 182 · Fort Smith, AR(-23) On 7/20/2007 aircraft N5542B, a Cessna 182 departed changler, AZ (chd) with a destination of russellville, KY (4M7). Approximately 10PM a final approach was made for forth Smith, AR (fsm) airport for a fuel stop by the pilot [privacy data omitted]. The…Accident 20070720015979ACessna A185F · Centennial, CO(-23) N78011 departed rwy 17 left, aircraft never got out of ground effect. Pilot attempted to land on highway perpendicular to end of rwy. Aircrat veered off of highway, struck a tree with left wing. Damage to left wing leading edge and spar and to float…Incident 20070720015819IBeech B35 · Salina, KS(-23) On July 20, 2007, at approximately 1300 CST, the aircraft (BE-35) departed runway 17 at the Salina airport (sln) in Salina Kansas. The pilot requested closed traffic for touch and go take offs and landings. The pilot was instructed to make a right turn…Accident 20070720015219AAmtr Flybaby · Hodgen, OK(-23) Aircraft had been missing since 07/20/07, it was located 07/25/07. The aircraft was located approximately one mile south of Oklahoma state highway 50 on rich mountain. The wreckage was confined to a small area east of a dirt road in a heavily wooded…Accident 20070720015069APiper PA17 · Scribner, NE(-23) While landing on runway 17, at the Scribner State airfield, Scribner, Nebraska, the pilot lost control allowing the aircraft to ground loop, damaging a runway light and collapsing the right landing gear. Wind 110 degrees at 09 KTS.Accident 20070720014529AAirtrc AT502 · Slaton, TX(-23) On July 20, 2007, at approximately 0930 CDT, N15400, an AT-500-502, piloted by [privacy data omitted], shortly after take off from runway 36 at the Slaton municipal airport (F49) in Slaton, Texas encountered uncontained engine failure during the climb.…Incident 20070720014329ILBL LBL105A · Winsor, CA(-23) Hot air balloon, landed in windsor, CA, during the ground crew's attempt to position the aircraft for retrieval. A gust of wind lifted the aircraft and dragged it across an access road and into a power pole at 20115PDT. No injuries. Minor damage to…Accident 20070720013029AScwzer G164B · West Liberty, IA(-23) Aircraft was airborne approximately 25-30 feet when engine lost power after birds flew by. Pilot could not keep aircraft airborne and landed straight ahead. Pilot caught tailwheel on fence at end of private airstrip, and then struck unseen culvert which…Accident 20070720012989AAmtr Bushcaddylsa · Chadron, NE(-23) The pilot and his passenger were enroute from morgan, Utah, to oshkosh, Wisconsin. While landing at Chadron Municipal Airport (cdr), Chadron, Nebraska, the pilot attempted to land on runway 20. Right before touchdown, approximately 300 feet past the…Accident 20070719020489ABeech C45H · Longmont, CO(-23) Flight instructor and student pilot were practicing single engine operations. With right engine at idle the left engine began to vibrate and not produce power. Right engine was brought back to full power and left engine was feathered. Right engine began…Incident 20070719020359ICessna T210N · Las Vegas, NV(-23) N9819Y departed IFR from kpvu to kvgt. Approximately 15 miles from kvgt, the PIC of N9819Y cancelled IFR and proceeded visually to rwy 25 of kvgt. PIC stated that he configured the airplane for landing but got disoriented and lost sight of the airport.…Incident 20070719020289ITcraft BC12D · Anchorage, AK(-23) On July 19, 2007, about 1815 Alaska daylight time, a Taylorcraft BC-12D airplane, N9897Y, sustained minor damage to its propeller when it struck a taxiway light while taxiing into campground parking at Merrill Field, Anchorage, Alaska. The airplane was…Incident 20070719019719IBeech A36 · Asheville, NC(-23) The pilot was flying an autopilot coupled ILS approach to runway 34 at Asheville Regional Airport. He became fixated on evaluating the autopilot performance as it had recently been repaired, and he did not realize he had not lowered the landing gear. At…Accident 20070719017719ACessna 150M · Woodland, CA(-23) Pilot and student were on the 45 degree entry to the downwind leg for a left downwind to runway 18 when they hit a hawk. The hawk came through the windscreen. The CFI thought he was high enough (1000 ft) from the field to make a landing, but realized…Incident 20070719016249IMooney M20C · Dansville, NY(-23) On July 19, 2007 at approximately 1730 hours, the pilot [privacy data omitted], the pilot of a Mooney aircraft depicting registration number N5681Q, made a gear-up landing on runway 32 at the Dansville airport located at 176 franklin street, Dansville,…Incident 20070719013929ICndair CL6002B19 · Lincoln, NE(-23) N932SW, CL-600-2B19 was operated by skywest airlines as united express flight 1000, a repositioning flight from Lincoln, NE (lnk) to chicago, IL. The flight crew reported that during climb to altitude they received an APU oil temperature caution…Accident 20070719013749ACessna 150J · Waldron, MO(-23) The pilot [privacy data omitted] departed form the uncontrolled airport for his second solo flight at about 1930 central daylight time. It was his first flight of the day, after three touch and go landings, he made a hard landing, bounced back into the…Incident 20070718832329IUnivar 1082 · Ottawa Lake, MI(-23) Aircraft was at cruise enroute to oshkosh Wisconsin over southern michigan/northern Ohio, when sudden engine failure caused the aircraft to lose power. The pilot had visual of vehicle test track which gave sufficient room for an emergency landing. The…Incident 20070718825369IPiper PA28181 · Janesville, WI(-23) The pilot [privacy data omitted] was giving flight instruction to [privacy data omitted], a student, in a PA-28-181, on July 18, 2007, at the rock county airport (jvl) Janesville, WI. They made a landing on runway 22 and Janesville air traffic control…Incident 20070718824529IBoeing 737823 · Minneapolis, MN(-23) On 07/18/07, at 2155Z, American 2422 (N909AN), a B737 enroute from dallas-ft worth TX, landed at Minneapolis-st Paul MN runway 35 and went off into the overrun area. The aircraft was able to return to the runway and parked on the ramp. There was no…Incident 20070718824499IPiper PA18150 · Miami, FL(-23) Pilot in command of banner tow aircraft states that after performing a pick of banner he discovers tow rope is wrapped around both main landing gear. Pilot completes short flight and the display of banner. Pilot attempts to perform soft field landing in…Accident 20070718020429ACessna 152 · Vero Beach, FL(-23) On Wednesday, July 18, 2007 at approximately 1200 EDT, N93574, a Cessna 152, piloted by [privacy data omitted] ran off the left side of runway 11R at Vero Beach Municipal Airport (vrb), Vero Beach, FL while landing. The pilot stated his airspeed was…Incident 20070718020379IGulstm GIV · New Orleans, LA(-23) After landing on runway 10 at msy, N990PT taxied to taxiway G-3 for parking at the FBO. N990PT was taxied between an army helicopter and a Wisconsin ANG merlin airplane. The left g-iv winglet struck the rudder and the right elevator of the merlin…Incident 20070718019209IPiper PA28181 · Dover, DE(-23) Cross country flight from chester county airport (40N) to salisbury, MD (sby). Performed emergency landing at Dover, afb due to total loss of electrical power. Pilot and USAF mechanics determined that the alternator belt was loose. Pilot called back to…Accident 20070718018559ACessna 172S · Pahokee, FL(-23) The flight instructor reported that after landing the aircraft bounced and veered to the right. Hoping to avoid another hard landing, the instructor initiated a go-around, however, the student did not relinquish control of the aircraft. The airplane…Incident 20070718015319ICessna 182H · Fairplay, CO(-23) Aircraft part of flight of two. Pilot reported engine trouble and landed 11 mile res due to lack of fuel.Accident 20070718015199ADtafr Combofc · San Luis Obisp, CA(-23) A steep approach was made to runway 29 at sbp with winds at 300 degrees, at 8 knots. The student pilot flared at 10' AGL with throttle at idle. The aircraft ballooned to about 15' AGL. The aircraft pitched nose down due to the reduction in airspeed. The…Accident 20070718014889ALkheed 382G · Mcgrath, AK(-23) Aircraft struck tail during takeoff rotation from a remote Alaska mining strip. The first indication of a problem occurred during climbout when the aircraft would not pressurize. Inspection upon landing revealed an approximately two foot tear in the…