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 20070330007139IPiper PA34200 · Tucson, AZ(-23) On March 30, 2007, 2230 UTC, Ryan field (ryn), Tucson, AZ, during landing phase, nose landing gear failed to extend. PIC declared emergency and landed aircraft in a gear up configuration, sustaining minor damage to the nose of the aircraft. No injuries…Accident 20070330005199AAmtr Wagabond · Jean, NV(-23) During a landing at Jean Airport, NV, this homebuilt airplane experienced a ground loop that caused the left landing gear to collapse and damage to the left wing and propeller. The pilot, who was the owner/builder of the airplane, had made several…Incident 20070330004239IPiper PA24250 · Plymouth, MA(-23) Pilot stated he landed on rw 33, landing gear lights all in the green, normal landing. Taxied to intersection of 24 and left gear collapsed. Minor damage to left wing tip and left gear door. Inspection of left gear revealed rod end had sheared off…Accident 20070330004209ATmpson Naviona · Los Banos, CA(-23) On 03/30/2007, at approximately 0144 hours PDT, a ryan navion-a, N4369K, experienced an in-flight breakup near Los Banos, CA. The private pilot and one passenger sustained fatal injuries; the airplane was destroyed. The flight departed from Los Banos…Incident 20070330004069ICirrus SR22 · Tulsa, OK(-23) On March 30, 2007, a Cirrus SR-22 received minor damage to one wingtip when it contacted a chain link fence during taxi for takeoff at the Tulsa International Airport, located in Tulsa, Oklahoma. The rated private pilot was not injured. According to a…Incident 20070330003549ICessna 414A · Hyannis, MA(-23) N6672C, C414, holding short of runway 24 at taxiway c, pilot was issued takeoff clearance, once the aircraft began to move the left main gear collapsed at 1420 EDT, 3/30/07. No injuries, minor aircraft damage to the left main gear door and left wing.Incident 20070329010179IMaule BEEDEEM4 · Tallahassee, FL(-23) Winds were 080 at 8 gusting to 15. Pilot requested runway 09 and was rolling (less than 15 mph) out when the tail rose and the prop struck the runway causing the airplane to veer right. It did not completely leave the runway. The pilot pushed the…Accident 20070329007049ACessna 180D · Winslow, AZ(-23) Airman advised the weather was good at inw, no wind, no traffic, straight in landing after a 3 hour VFR flight. After touchdown (wheel landing) and beginning to slow on landing rollout, he reached down to retract the flaps and when he looked back up,…Incident 20070329006329IBeech 1900D · Springfield, IL(-23) Shortly after departure from mdw pilot stated that the aircraft felt as if it had a flat nose tire. Aircraft declared an emergency prior to landing at spi. Aircraft landed without incident, and without any problems with suspected nose tire. This…Accident 20070329005779APiper PA22 · Enumclaw, WA(-23) Pilot stated that she lost power and tried switching tanks without success. Landed in a field but the nose wheel dug in and the aircraft ground looped.Incident 20070329005669IBoeing 717200 · Atlanta, GA(-23) At approximately 2105L, Thursday, March 29, 2007 an airtran airways B-717-200 aircraft struck a stationary galley service truck during pushback from gate D-1 at Atlanta's Hartsfield-jackson international airport. The aircraft suffered minor damage to…Accident 20070329005549ADoug DC983 · Orlando, FL(-23) Complete loss of right side hydraulic pressure and quantity. Flight crew had to use alternate extension control lever to extend landing gear. Both main landing gear deployed, nose landing gear remained in the up and locked position. Emergency declared…Incident 20070329005249ILear 55LEAR · Amarillo, TX(-23) Crew aborted first take-off run on runway 22 at approximately 100 knots when the right thrust reverser system alerted and illuminated the caution light for thrust reverser unlocked. The bleed air and deployed lights did not illuminate during the…Accident 20070329004559AAmtr GARANCO162F · Foley, AL(-23) Engine lost power on climbout, instructor took control and aircraft made an emergency landing. Aircraft skids struck ground with enough forward momentum for aircraft to nose over onto right side.Incident 20070329004439ICessna 210M · Sparta, TN(-23) The pilot stated that he was making a practice GPS approach with a new piece of equipment. He was distracted by learning how to use the equipment and forgot to put the landing gear down. He touched down and damaged the propeller, belly of the aircraft…Incident 20070329004099ISwftms GC1B · Ramona, CA(-23) The pilot said he forgot to put the landing gear down before landing. He normally uses a before landing checklist and the acronym gumps as his final check. He said he became distracted trying to spot traffic in the pattern that was pointed out by the…Incident 20070329004019IScwzer G164A · Port Isabel, TX(-23) Aircraft brakes locked up on landing. Aircraft ended up on its nose with q-tipped props.Incident 20070329003479IGulstm 200 · Oklahoma City, OK(-23) On March 29, 2007, at approximately 16:00 CDT, an ia-galaxy aircraft struck runway threshold lights off the end of runway 17L during landing rollout at the Wiley Post Airport, located in bethany, OK. The aircraft had arrived from huntsville, al and was…Accident 20070329003459APiper PA18150 · Sweetwater, TX(-23) During a maintenance flight on a replacement engine with approximately 3 hours total time, the throttle linkage stuck, then broke. The engine power ended up at a reduced setting, causing the pilot to make an emergency landing. The aircraft was damaged…Accident 20070328019409AAlon A2 · Ravenna, OH(-23) Aircraft departed youngstown (yng) at approximately 1950 for akron (akr). At 4500' the engine quit. It was able to be restarted but it sputtered and quit again. A controlled landing was attempted in an open field but the aircraft struck a ditch as it…Accident 20070328014829APiper PA28151 · Howell, NJ(-23) On March 28, 2007 at approximately 2010 EDT, a Piper aircraft, PA-28-151, N33521 impacted trees in a residential area in Howell, NJ, while on approach to the allaire (blm) airport. VFR conditions prevailed. At 23:55 uct (zulu) N33521 contacted mcguire…Incident 20070328010199ICessna 152 · Ocala, FL(-23) Engine failure inflight (connecting rod through case). Minor damage to a/c during off-airport landing.Incident 20070328005809IMooney M20C · Ormond Beach, FL(-23) Mooney-2-C aircraft's landing gear collapsed on landing, due to landing gear handle latching mechanism, which failed to lock handle forward (gear down). Airworthiness inspector observed discrepancy during gear swing test, which was performed at rams…Incident 20070328005319IBeech 95B55 · Terrell, TX(-23) At approximately 8:40 am, during approach into Terrell airport, pilot noticed no green light indicating gear down. Pilot stated he pressed light and saw the light flicker green. Pilot stated mechanical indicator showed gear in down position. Pilot made…Incident 20070328003979ISnias AS350BA · Kahului, HI(-23) PIC reported the tail rotor pedals quit functioning during flight. Declared an emergency and returned to ogg airport. Able to land with little or no forward speed. Aircraft spun around twice before touchdown. Inspection revealed the tail rotor gear box…Incident 20070327004979IPiper PA24250 · Palmdale, CA(-23) Departed concord, California (ccr) enroute to las vegas, Nevada (las) via lancaster, California (wjf). Prior to arrival the pilot [privacy data omitted] listened to las ATIS and heard that the airport had windshears and that the airport would be closed…Incident 20070327004739ICessna 750 · Salt Lake City, UT(-23) The flight departed addison, Texas on March 27, 2007 for a business trip to Idaho falls, Idaho under 14 CFR part 91 and intended to return to addison later that same evening. Upon departure from Idaho falls, Idaho at approximately 16:00 MDT during the…Accident 20070327004599ARobsin R44RAVENII · Pontevedrabeach, FL(-23) Flight instructor and student pilot prepared for a flight from craig municipal airport, Florida, on an orientation flight for the student, bound for st. augustine, Florida then returning to craig municipal. Aircraft departed airport westbound and turned…Incident 20070327004229ILear 35LEAR · Lincoln, NE(-23) Pilots heard a thump on takeoff. Returned to airport and landed overweight. Was reported that the aircraft struck a fox. No damage to the aircraft.Incident 20070326011459ICessna 172S · Moore Haven, FL(-23) On March 26, 2007, on about 1856 eastern standard time, a Cessna 172S aircraft, N57FH registered to whome & shortys inc. operating as a 14 CFR part 91 flight, made an emergency landing in a field in Moore Haven, Florida. Visual meteorological conditions…Incident 20070326006769ICessna 421C · Hickory, NC(-23) Nose landing gear collapsed after aircraft had landed and was on roll out.Accident 20070326006629AAmtr ROTORWAY162F · Malta, IL(-23) Helicopter departed dekalb airport (dkb) for a local flight. At approximately 7 miles west of dkb a yellow engine warning light came on the fadec display indicating a code #2 warning and the pilot decided to make a precautionary landing in a corn field…Accident 20070326005559ACessna 172R · Orlando, FL(-23) The student pilot was on a solo cross country flight. He was on final leg of the trip back to korl. His first attempt of a landing resulted in a go around. The second attempt took the aircraft off the left side of the runway into the grass. The pilot…Incident 20070326003969ICessna U206B · Juneau, AK(-23) The aircraft engine quit over auke bay. The pilot was able to land on the beach of portland island without further damage or injury. The pilot stated that he actually landed 50 feet shy of the island, but was able to hydro-plane in to the shore, and…Accident 20070326003499ALear 36A · Newport News, VA(-23) March 26, 2007 lr JET-36A, N527PA was operated by phoenix air group as flight 327. At approximately 0725 EDT N527PA departed Newport News/Williamsburg International Airport/phf on runway 20. On the takeoff roll the left main landing gear tires blew. The…Accident 20070325832249ACessna 150M · Austin, IN(-23) On 03/25/2007 at 1724 EST Cessna aircraft, CE-150-M, registration number N66673 crashed after takeoff from a 1,200 feet long grass strip in Austin, Indiana. The aircraft clipped tree tops and hit the corner of a porch and roof of a home ending on the…Incident 20070325015849ICessna T210N · New Cumberland, PA(-23) After take-off on runway 30, while climbing thru 300-500 feet, the engine developed a miss and became rough. A return to the field was requested and an uneventful landing was made on runway 08. Maintenance personnel at cxy found excessive moisture and…Accident 20070325008219ABeech B90 · Augusta, GA(-23) This aircraft departed pdk in atlanta, GA enroute to hilton head (hxd) on an instrument flight rules clearance. The aircraft was in visual conditions the entire time. The pilot reported that both generators failed and he tried to reset them without any…Accident 20070325004569ABbavia 7ECA · Wawayanda, NY(-23) While giving dual instruction to a student pilot on spin entry and recovery at approximately 0930L over the union fields, in Wawayanda, new york 110973/41'19N.825/74'28.681 w/ upon recovery from a spin attempted to apply engine power, engine stopped…Incident 20070325004429IPiper PA22150 · Clarksville, TN(-23) The tail wheel aircraft landed in a 3 point attitude and swerved slightly right of centerline. The pilot corrected back to the left and lost directional control. The aircraft ground looped to the left and slid off the runway to the left. The aircraft…Incident 20070325004009ICndair CL6002B19 · Omaha, NE(-23) N8409N, CL-600-2B19, was operated by pinnacle airlines as northwest airlink flight 5702 from memphis, TN, to Omaha, NE. The crew reported to the Omaha air traffic control tower that they had no flaps. The aircraft landed safely at Omaha. The crew wrote…Incident 20070325003989IPiper PA28R180 · Coalinga, CA(-23) On 03/25/2007, while enroute from columbia airport (O22) to Harris ranch (3O8) in Coalinga, CA, at approximately 25 minutes into the flight, a loud squeal was heard over both the pilot's head set and the cabin speaker, and the aircraft experienced a…Accident 20070325003829AAmtr ROTORWAY162F · Camarillo, CA(-23) On March 25th 2007, N496SB an amateur built rotorway exec 162F helicopter crashed during an attempted landing at Camarillo Airport (cma). The pilot and sole occupant [privacy data omitted] was uninjured but the aircraft sustained substantial damage.…Accident 20070325003519APzlwar PZL101A · Spicewood, TX(-23) On March 25, 2007, approximately 10:00 am, the pilot in command departed Spicewood airport, Spicewood, Texas, on runway 17. Approximately midfield and 500 AGL, the pilot experienced a power loss. Trying to turn downwind to land back at Spicewood, the…Incident 20070324006349ICvac 24027 · Ypsilanti, MI(-23) N153PA on approach to yip reported a large bang followed by buffeting. Right hand inboard (wing) leading edge missing upon post flight inspection. Westland police dispatched to intersection of marquette & carlson where a caller reported seeing a large…Accident 20070324006259AUnivar 1081 · Lawrenceville, GA(-23) Pilot was landing on runway 25 at Briscoe field (lzu) in Lawrenceville, GA. As he was touching down, it appeared to the pilot that he was drifting to the left due to a right crosswind. The flight controls were adjusted to compensate for this condition…Accident 20070324005489ABeech 200BEECH · Angel Fire, NM(-23) On March 24, 2007 at approximately 1050 local time, the pilot [privacy data omitted] , pilot-in-command and sole occupant of N771HC, a Beechcraft model BE-200 multi-engine, turbo-propeller powered airplane, landed on runway 17 at the Angel Fire Airport…Accident 20070324005179APiper PA28140 · Blair County, PA(-23) Aircraft lost power during cruise flight. Pilot described conditions very similar to carburetor icing. Upon initial application of carburetor heat, pilot selected carburetor heat off due to the associated decrease in RPM and engine roughness due to ice…Accident 20070324005039ABeech B24R · Moncks Corner, SC(-23) Aircraft landed short of runway 23 at Berkeley co. airport after complete electrical failure. Aircraft sustained substantial damage, no fire, 4 persons on board, no injuries.Accident 20070324004519APiper PA32R301 · Jacksonville, MD(-23) Aircraft took off from harford county airport in churchville (0W3). People in the area did not see the aircraft crash but heard the impact. Aircraft appeared to have dove straight in. The crash site is pretty much contained in a small area. There were 3…